Months elapsed formula

[htchandler]

I tried to use the excel recommended formula for this but it did not work. I need a formula to count the whole months between "Today" and the date the individual started in their job. For some individuals it may be less than a month, or it could be several years, I need the answer in number of months. Any ideas.

 

[Jonmo1]

Try

=DATEDIF(A1,TODAY(),"m")

A1 = date started job.

 

[barry houdini]

If it's less than a month what should be the answer? Is it zero or would you want it to be 1 if it's over 15 days?

Try using DATEDIF in either case, e.g. with hire date in A1

=DATEDIF(A1,TODAY(),"m")

only counts whole months so anything less than a month will be 0....or to round to the nearest month (roughly)

=DATEDIF(A1,TODAY()+15,"m")

 

[htchandler]

The formula:

=datedif(date started,today()+15,"m"

just sits in the cell, it will not actually calculate to give me a numbers or give me an error message. I double checked that the cell is not locked and there are no macros to turn on. Any ideas what would cause this?

 

[barry houdini]

You need a closing parenthesis

=datedif(date started,today()+15,"m")

 

[htchandler]

The format for the date is "DD-MM-YY" if that makes a difference.

 

[htchandler]

The formula is still doing the same thing even after closing the perenthesis.

 

[Jonmo1]

You need the closing parenthesis as barry pointed out.

Also, format the cell with the formula as GENERAL
Then RE-enter the formula


The format of the date shouldn't matter, as long as the actual value is actually a date.

What does this formula return
=ISNUMBER(A1)
where A1 is your date.

 

[htchandler]

Changing the cell format to general is what the trick was. Thank you for the help everyone!!!

Henry