This does answer my question to a point, but I just want it to run off todays
date, is that possible?

Craig

"Tushar Mehta" wrote:

To answer your other question, =DATEDIF(D10,E10,"m"), where D10
contains the earlier date and E10 the later date. A very useful
function that has been in XL for several releases but remains
mysteriously undocumented. Even more mysterious is that it was
documented in 2000 help and the documentation was pulled in the next
release!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am building a spreadsheeet, where If a cell has a "Yes" in it is is work
.75 and a "no" equals 0. I know a IF statement will help, but I don't know
how.

I also want Excel to caculate from an inputted date how many moths ago it
was.


Can anyone help?


Craig