Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel
Resolved · Low Priority · Version 2003
Reply Mon 23 Jun 2008, 16:43Delegate 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
For upcoming training course dates see: Pricing & availability
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
Attached files...
Calculating months.xls
|