| 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 Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use the WEEKDAY function in the Excel Business Solutions Directory |