I having a problem using the workday function. I would like to list Monday to Friday dates in a column for the year and I cannot see how to do this.
For example: 02/19 is Monday and then 02/26 is the following Monday for the next week.
Col A
02/19/24
02/20/24
02/21/24
02/22/24
02/23/24
02/26/24
Is there a different (easier way?) function I should be using?
Thanks ahead for any help - suggestion or solutions.
Hallo
⇒ Sheet ⇒ Fill Cells ⇒ Fill Series [x]Date [x] Weekday
Thank you, easy when one knows. Have a good week.
I would seriously suggest to not do it the way described in the question. There may be rare reasons to use a row for saturday or sunday exceptionally, or at any time in the future to enahnce the sheet, and to use the previously unused rows for comments or special sums or…
If you feel absoutely sure the 5-day-week is what you need for now an all the time to come, do it the way demonstrated in the attached example. In that example not only the steps are adapted to your wishes, but also the first workday (monday) of every week is emphasized by using a special format. (ConditionalFormat setting).
disdask102307WorkdaySeries.ods (31.9 KB)
Hallo
…There is also
=WORKDAY(A2;1; [optional some Cellrange with holydays] )Lupp,
The business (Wall Street) is only open Monday - Friday. So I never have to worry about weekends. Thanks for the input, I appreciate the reason.