Tech Support Guy banner
Cancel

Scheduling Deadlines in Excel

655 Views 1 Reply 2 Participants Last post by  etaf, 
R
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.
Save
Like
Status
Not open for further replies.
1 - 2 of 2 Posts
etaf
this will put the date to a monday
=IF(WEEKDAY(B1+75,2)=7,B1+76,IF(WEEKDAY(B1+75,2)=6,B1+77,B1+75))
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
try

=WORKDAY(B1,75)
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
Save
Like
1 - 2 of 2 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top