| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate total of months that have passed?
I want to know how many months have passed since a certain date. There is a
start date and an end date. I want to calculate how many months are in that period. For instance if the start date is 05-01-01 and the end date is 05-03-01 two months have passed. |
|
#2
|
|||
|
|||
|
Hi,
You can use =DATEDIF(A1,B1,"m") where, A1 = 05-01-01 B1 = 05-03-01 "m" = month ("d" for days, "y" for Years, "ym" for Months Excluding Year, "yd" for Days Excluding Years and "md" for Days Excluding Months And Years) Regards Akhilesh Dalia akhileshdalia<athotmail<dotcom "jaydubs" wrote: I want to know how many months have passed since a certain date. There is a start date and an end date. I want to calculate how many months are in that period. For instance if the start date is 05-01-01 and the end date is 05-03-01 two months have passed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
| how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
| Need number of months or weeks passed from formula | Excel Worksheet Functions | |||
Linear Mode
