Getting correct number of months between a date and today

Devon Eddy

Hello, I'm trying to work with a formula to find the number of months between a static date and today for a PTO sheet (see attached). I thought I had the formula worked out, but can't get it to seem to work..

Thanks,

-Devon

MCorbin

Try this (you'll need decimals)

=(NETDAYS([Date Submitted]@row, TODAY()) / 365) * 12

Or, if you only want the integer...

=ROUND((NETDAYS([Date Submitted]@row, TODAY()) / 365) * 12)

MCorbin

Try this (you'll need decimals)

=(NETDAYS([Date Submitted]@row, TODAY()) / 365) * 12

Or, if you only want the integer...

=ROUND((NETDAYS([Date Submitted]@row, TODAY()) / 365) * 12)

Devon Eddy

That worked perfectly! Thank you very much :)