Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sheet with expiration dates
I need to set up a sheet that will show how many day's i have left before a
contract will expire. |
#2
|
|||
|
|||
One way:
A1: <expiration date A2: =TODAY()-A1 Format A2 as General. In article , "expiration dates" <expiration wrote: I need to set up a sheet that will show how many day's i have left before a contract will expire. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic reference to a sheet | Excel Worksheet Functions | |||
Subset of one sheet on another sheet | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |