| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date() function error
In office pro 2003, excel the dates between function mis calculates i.e.
creating a amortization for simple interest using the days() between function mis-calculates the number of days. i.e. aug 10, 2006 to sept 5, 2006 is 27 days, date() function reports 25 days, causing interest and principle to be wrong and ending balance to be incorrect. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Date Error - HELP! | Excel Discussion (Misc queries) | |||
Threaded Mode
