|Forum Topic||Post Reply Login|
Excel Formula For Day Of Week
Rate this:(3.5/5 from 2 votes)
|Hi 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.
|Posted by icecoldexcel on|
|Replies - Displaying 1 to 2 of 2||Order Replies By: Most recent | Chronological | Highest Rated|
Rate this:(3.5/5 from 4 votes)
Let me know if this helps.
|Posted by jerry_maguire on|
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).
Rate this:(3/5 from 2 votes)
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 Excel Helper on|
|Displaying page 1 of 1|
|Find relevant Excel templates and add-ins for Excel Formula for day of week in the Excel Business Solutions Directory|