Date function in Excel

[MBLR]

Assume that I have three cells. I will enter date1 in first cell and date2 in second cell. Can I get the difference in month in third cell?

For Eg:
Date 1 Date 2 Result in months
_______________________________________________
| 23/1/2002 | 22/2/2002 | 1 |
-----------------------------------------------

 

[Hasit]

If dates appear in A1 and B1, try this formula in C1:

=MONTH(B1-A1)

Make sure that C1 is formatted as GENERAL

 

[xlbo]

Define "Month" - do you mean number of full calendar months , no. of 30 day blocks ....it makes a difference Rgds
~Geoff~

 

[Scott02]

Try =(A2-A1)/(365/12)

Produces a decimal value

 

[iGrant]

This is a bit long winded, but

=IF(YEAR(C17)>YEAR(B17),SUM((YEAR(C17)-YEAR(B17))*12,MONTH(C17),12-MONTH(B17)),MONTH(C17)-MONTH(B17))

seems to work OK.

BUT it won't work if the date in column B is earlier than that in column A - if this is likely to happen then some more work will be required on the formula!