![]() |
How do I set a start and expiration date using IF function
I want to be able to have the computer to give me a expiration date at the
end of the 6th day starting today |
How do I set a start and expiration date using IF function
Hi John
You can type a date in one cell e.g. A2 or you can press Ctrl+; semicolon to get today's date and in an other cell just type =A2+6. HTH John "John A" wrote in message ... I want to be able to have the computer to give me a expiration date at the end of the 6th day starting today |
How do I set a start and expiration date using IF function
Hi John,
In the expiration cell enter =TODAY()+6 "John A" wrote: I want to be able to have the computer to give me a expiration date at the end of the 6th day starting today |
All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com