| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to use Today() in calculations?
I used =today()-date_of_joining to calculate months, I get 4. But when I
subtract 2 casual leaves, I don't get 2. What am I supposed to do? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to use Today() in calculations?
try
=MONTH(TODAY())-MONTH(G5) -- Don Guillett Microsoft MVP Excel SalesAid Software "ghitorni" wrote in message ... I used =today()-date_of_joining to calculate months, I get 4. But when I subtract 2 casual leaves, I don't get 2. What am I supposed to do? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =TODAY() | Excel Discussion (Misc queries) | |||
| =TODAY() | Excel Worksheet Functions | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| Today() | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Hybrid Mode
