ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to calculate total months from month/year (https://www.excelbanter.com/excel-discussion-misc-queries/1550-how-calculate-total-months-month-year.html)

patti

how to calculate total months from month/year
 
I am looking for help with getting a formula to calculate employee's
anniversary's in total of months. In column B I have date Jan-2002. How do
I get column C to give me total in months as of dec 2004?

Frank Kabel

Hi
use dATEDIF. See:
http://www.cpearson.com/excel/datedif.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"patti" schrieb im Newsbeitrag
...
I am looking for help with getting a formula to calculate employee's
anniversary's in total of months. In column B I have date Jan-2002.

How do
I get column C to give me total in months as of dec 2004?




All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com