ExcelBanter - Date Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Function (https://www.excelbanter.com/excel-discussion-misc-queries/19893-date-function.html)

ACase

Date Function

Hello,

I need to write a function which gives me the # of months between two dates.

Example.

Start Date = 01/01/2005
End Date = 03/31/2010

Function result = 63

Any help would be much appreciated.

Thanks
Arno

Jason Morin

=DATEDIF(A1,B1,"m")+1

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

I need to write a function which gives me the # of
months between two dates.

Example.

Start Date = 01/01/2005
End Date = 03/31/2010

Function result = 63

Any help would be much appreciated.

Thanks
Arno
.

ACase

Thank You

"Jason Morin" wrote:

=DATEDIF(A1,B1,"m")+1

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

I need to write a function which gives me the # of
months between two dates.

Example.

Start Date = 01/01/2005
End Date = 03/31/2010

Function result = 63

Any help would be much appreciated.

Thanks
Arno
.

All times are GMT +1. The time now is 03:27 PM.