Hello,
Ive created a monthly and yearly dynamic calendar with the formula =DATE(A2,A1,1) and used a combo box to get the year to generate. I was wondering how I would be able to filter weekends out of this calendar.
Hello,
Ive created a monthly and yearly dynamic calendar with the formula =DATE(A2,A1,1) and used a combo box to get the year to generate. I was wondering how I would be able to filter weekends out of this calendar.
For subsequent dates you could just use this in A4:
=A3+1
and copy down.
However, if you want to skip over weekends completely, you could do this:
=A3 + IF(WEEKDAY(A3,2)=5, 3,1)
This does not take account of the first date being either a Saturday or a Sunday, so you would need to apply something similar in A3.
Hope this helps.
Pete
If your weekends are Sat & Sun, you could use the Workday function
Excel 365 (Windows) 32 bit
A B 1 11 2 2021 3 01/11/2021=WORKDAY(DATE(A2,A1,0),1) 4 02/11/2021=WORKDAY(A3,1) 5 03/11/2021=WORKDAY(A4,1) 6 04/11/2021=WORKDAY(A5,1) 7 05/11/2021=WORKDAY(A6,1) 8 08/11/2021=WORKDAY(A7,1) 9 09/11/2021=WORKDAY(A8,1) 10 10/11/2021=WORKDAY(A9,1) 11 11/11/2021=WORKDAY(A10,1)
Sheet: Main
Try Network days to check if it is or isnt, this will enable you to exclude Holidays or special observed days if you need....
This should be your SECOND DAY
I would use the same fashion to get the FIRST DAY as the month doesn't always start in the middle of the week...Please Login or Register to view this content.
Please Login or Register to view this content.
-If you think you are done, Start over - ELeGault
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks