Ask Your Question

I have a cell formatted for date (1/2/2019) and I want to drag it down to autofill the entire year but only weekdays. Is there a way to do that?

asked 2018-12-31 19:36:49 +0200

NealAZ gravatar image

Thanks in advance for the help.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-31 20:06:12 +0200

Lupp gravatar image

updated 2018-12-31 20:06:53 +0200

Dates are by default represented by integer numbers in spreadsheets. If you did so, the effects of dragging and the results of calculations will not at all depend on the format you chose.

I don't know a way to create "broken series" by dragging. But you can start with any date in cell A2 e.g, and enter into the cell below the formula =IF(WEEKDAY(A2;2)=6;A2+2;A2+1). If you fill this formula down as far as needed, you will get the sequence of dates skipping sundays.

(If you want to treat dates as texts it's more complicated.)

By the way: Th only date format meeting all the needs that may occur is "ISO 8601 (extended)". The respective formatting code is YYYY-MM-DD.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-31 19:36:49 +0200

Seen: 71 times

Last updated: Dec 31 '18