![]() |
Formula for adding a day to a particular date.
I have a spreadsheet that has a formatted cell for todays date. What I need
is a formula that looks to see if it is Sunday thru Thursday or Friday and Saturday. Depending on the answer I need it to add 1 day or three days to the current date. |
Formula for adding a day to a particular date.
You can use WEEKDAY function with IF to get what you want...
"Rbenngas" wrote: I have a spreadsheet that has a formatted cell for todays date. What I need is a formula that looks to see if it is Sunday thru Thursday or Friday and Saturday. Depending on the answer I need it to add 1 day or three days to the current date. |
All times are GMT +1. The time now is 07:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com