| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
