Excel Formula for day of week

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

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

	Use the WEEKDAY function 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

	Format cells to show dates as the day of the week 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

Displaying page 1 of 1