Home > Forum Home > Analyzing Corporate Financial Data > Excel Formula for day of week > Use the WEEKDAY function Share

Use the WEEKDAY function

Excel Help for Use The Weekday Function in Analyzing Corporate Financial Data


Forum TopicLogin

Use The Weekday Function

Rate this:
(3/5 from 1 vote)
ConfusedYou 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
 
View Full Post

Find relevant Excel templates and add-ins for Use the WEEKDAY function in the