calculate number of months

T

townsendmama

Is there a formula that will calculate the number of months from a certain
date backwards?

For example, I have a date of 06/30/2008 - Then I have 78 employees with
various anniversary dates. I have the years calculated but I need to know
how many months from their date to June 30th. It does fine if their date is
January -June but for instance I need September to calculate as 9 months
(Sep-June).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate number of months based on one date 1
Calculate # of months if a date is given 4
Calculate a quarter 16
'08-'11 Days of the Wk per Month 2
Number of Months Between Two Dates Entered 13
Excel Formula for years and months 2
Calculate Complete Months Between Two Dates 15
CALCULATE DUE DATE & RESTART DATE 4

Top