Tech Support Guy banner

Scheduling Deadlines in Excel

655 Views 1 Reply 2 Participants Last post by  etaf
I am using Excel to schedule deadlines using this formula: =IF(ISBLANK(B1),"",B1 -75) where B1 is my end date and 75 days is the start date being calculated. However, I do not want Excel to return a date that is on a weekend or holiday. I do need to include weekends and holidays in the count though. How do I format the cell to do this?

Also, I am using the same formula in another instance but I do not want it to count weekends and holidays nor return on a weekend and holiday.

Thank you for any suggestions.
Not open for further replies.
1 - 2 of 2 Posts
this will put the date to a monday
and count 75 days , and monday if a Sat or Sun

is that what you wanted ?

I'm looking at the 75 workdays version

as i posted the last sentence

you can add holidays into the workday() function

but would need a lookup for the first function offered for 75 days
need to look at a betterway to do that
See less See more
1 - 2 of 2 Posts
Not open for further replies.