Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

How to exclude weekend days from a date formula field

I have an old calculation that either I haven't been paying attention to in my tasks or seems to all of a sudden stopped working. I have a date formula field called Start Date with Check that is suppo...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Try this

WeekdayAdd([Start Date],0)
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
First one worked perfectly, 2nd one gave me an error. But now I'm trying to filter out holidays for my Estimated Started Date (which was just a Work Date formula field, [Start Date with Check]} and tried this calc to add a day after the holidays and this didn't work: 
If([Start Date with Check]=ToDate("01-01-2018"),WeekdayAdd([Start Date with Check],1),
[Start Date with Check]) 

yikes I'm off somewhere again! :(