Is there a way to modify the DAYS360 function to accomadate a 365
 

Trying to use DAYS360 function to calculate days between date over multiple
year period. Need a 365 day year function. Can this be changed?

Is there a way to modify the DAYS360 function to accomadate a 365
 

the DATEDIF() function will help. First you must install the analysis
toolpack (<Tools<Add-Ins... and check Analysis ToolPak). Used in the
following manner will achieve what you are looking for:

=DATEDIF(year1,year2,"d")

Where year1 < year2. The function will return #NUM! if year1 year2.
--
Regards,
Dave


"Linda Miller" wrote:

Trying to use DAYS360 function to calculate days between date over multiple
year period. Need a 365 day year function. Can this be changed?

Is there a way to modify the DAYS360 function to accomadate a
 

Sorry, I meant date1 and date2 (not year1, year2):

=DATEDIF(date1,date2,"d")

Where date1 < date2

--
Regards,
Dave


"David Billigmeier" wrote:

the DATEDIF() function will help. First you must install the analysis
toolpack (<Tools<Add-Ins... and check Analysis ToolPak). Used in the
following manner will achieve what you are looking for:

=DATEDIF(year1,year2,"d")

Where year1 < year2. The function will return #NUM! if year1 year2.
--
Regards,
Dave


"Linda Miller" wrote:

Trying to use DAYS360 function to calculate days between date over multiple
year period. Need a 365 day year function. Can this be changed?