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 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Confused
  1. Select the cells that contain dates that you want to show as the days of the week.
  2. On the Home tab, click the dropdown in the Number Format list box, click More Number Formats, and then click the Number tab.
  3. 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 on
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