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

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