| 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 Topic | Login |
Use The Weekday Function | Rate this: (4/5 from 2 votes) |
 | You 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: =IF(ISBLANK(Q45),"",IF(WEEKDAY(Q45)<=WEEKDAY(K45),Q45-K45-2,Q45-K45)) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use the WEEKDAY function in the Excel Business Solutions Directory |