Home > Forum Home > Analyzing Corporate Financial Data > Excel Formula for day of week Share

Excel Formula for day of week

Excel Help for Excel Formula For Day Of Week in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Excel Formula For Day Of Week

Rate this:
(3/5 from 1 vote)
ConfusedHi everyone, require your help:

I'm trying to find a formula to do the following:

I have a fixed date cell which I enter manually and a second cell which takes the date from that cell and simply adds 20 to it, establishing the deadline date of 20 days.

The problem is, if the deadline date is a friday or a saturday, it needs to come back to thursday.

I'm looking for something like "e1+20" "if=Sat" then -2 "if=Fri" then -1 resulting in the outcome of Thursday.

Any takers?

Thanks

 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
You can use the WEEKDAY function to determine the day of the week on the date in question.  This will return 6 for Friday and 7 for Saturday (it starts at 1 for Sunday).

Therefore to add 20 the formula will be:
=[date] + IF(WEEKDAY([date])=6,19,IF(WEEKDAY([date])=7,18,20))
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Excel Formula for day of week in the