Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
difference in months
Hi there
I have 2 dates and i want to calculate the difference in months not years Any help will be appreciated Thanks Londoner |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
difference in months
Try theses out. I found them in the Excel HELP.
=MONTH(A3)-MONTH(A2) Calculates difference in months within same year. =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3) Calculates difference in months for dates occurring in different years. Les "Londoner" wrote: Hi there I have 2 dates and i want to calculate the difference in months not years Any help will be appreciated Thanks Londoner |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
difference in months
With the first date in G1 and the 2nd date in G2 try:
=DATEDIF(G2,G1,"m") If the dates will not always be witht he earliest date in G1 then use: =DATEDIF(MIN(G2,G1),MAX(G2,G1),"m") -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Londoner" wrote in message ... Hi there I have 2 dates and i want to calculate the difference in months not years Any help will be appreciated Thanks Londoner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference between two months | Excel Worksheet Functions | |||
difference between two dates in years, months and days. | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions |