ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula for adding a day to a particular date. (https://www.excelbanter.com/excel-discussion-misc-queries/252083-formula-adding-day-particular-date.html)

Rbenngas

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.



Sheeloo

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