Thread: Is there a way to modify the DAYS360 function to accomadate a 365
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
  
Posts: 176
Default 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?
Reply With QuoteReply With Quote