Home > Forum Home > Analyzing Corporate Financial Data > Nested IF Statement - Subtract Weekend Days > 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:
(4/5 from 2 votes)
ConfusedYou can use the WEEKDAY function on the dates which will return 7 for Sunday and 1 for Saturday.  To test if the weekend falls between the 2 dates that are within one week apart, the formula would be:

 Excel Business Forums Administrator
 Posted by on
View Full Post

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