Excel

Resolved · Low Priority · Version 2003

Mon 23 Jun 2008, 16:43 Delegate Selina said...

Selina has attended:
Excel Intermediate course

Excel

Is there a simpler function I can use to calculate the number of months between two dates? I am currently using the following:

=(YEAR($K$1)-YEAR(G33))*12+(MONTH($K$1)-MONTH(G33))

Where:

$K$1 = today's date which I have situated in a cell outside the table

G33 = a start date of an employee

Thanks

Sun 6 Jul 2008, 21:28 Trainer Rajeev said...

RE: Excel - Calculating Months!!!

Dear Selina

Thank you for attending the Excel Intermediate course. I hope you enjoyed the course and benefited from it.

There ifs definitely an easier way to calculate no. of months!!

I have attached a spreadsheet for your reference. Please note that I have saved the spreadsheet in the Formulae view (this means that you can see the Formulae instead of results in the cells). You can do this by using the Shortcut command CTRL +` (this is the key below your Esc key on the keyboard)

You