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

G

Guest

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

Guest

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.
 
G

Guest

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

=DATEDIF(date1,date2,"d")

Where date1 < date2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAYS360 function for 365 day year 3
Day Number For 365 Day Year 5
calculating number of days between two dates 3
Determine years betwen 2 dates 2
DAYS360 3
More effective than DAYS360? 1
Excel formula to incrementally increase a value by 1 every 365 day 2
Days365? 1

Top