# Excel Formula for day of week

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

 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.Any takers?Thanks Posted by icecoldexcel on 02 Jun 2011
 Replies - Displaying 1 to 2 of 2 Order Replies By: Most recent | Chronological | Highest Rated
 Rate this: (3.5/5 from 4 votes) Select the cells that contain dates that you want to show as the days of the week. On the Home tab, click the dropdown in the Number Format list box, click More Number Formats, and then click the Number tab. Under Category, click Custom, and in the Type box, type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on). Let me know if this helps.Regards,Jerry. Jerry M Posted by jerry_maguire on 21 Dec 2020
 Rate this: (3/5 from 2 votes) 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 Excel Helper on 02 Jun 2011
 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