| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expiration Date countdown | Excel Worksheet Functions | |||
| Conditional formatting referencing date of expiration | Excel Worksheet Functions | |||
| How do I set up a formula for calculating an expiration date? | Excel Worksheet Functions | |||
| color code a row by expiration date? | Excel Worksheet Functions | |||
| How do I create an alert of expiration date in Excel? | Excel Discussion (Misc queries) | |||
![John A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
