ClaraBarton
Registered User.
- Local time
- Today, 05:19
- Joined
- Oct 14, 2019
- Messages
- 524
I need 728 successive weekdays starting with a date.
This makes the correct number of days but it includes weekends. Doesn't the "w" limit it?
So I limit the days to
This limits the dates to weekdays but brings the total to 520.
What formula would give me 727 week days?
Code:
Between #5/1/2024# And DateAdd("w",727,#5/1/2024#)
So I limit the days to
Code:
<>7 and <>1
What formula would give me 727 week days?