ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I set a start and expiration date using IF function (https://www.excelbanter.com/excel-worksheet-functions/221708-how-do-i-set-start-expiration-date-using-if-function.html)

John A[_2_]

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

John[_22_]

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



Eduardo

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