| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can XIRR Work on Dates That Move Backwards in Time?
I have used XIRR in the past with a row of dates that move from earliest to
oldest date as you move right to left in the spreadsheet. The corresponding data values are directly below the dates. Today I worked with a spreadsheet where the dates move opposite: Earliest date is on the far right, and more recent dates move toward the left. Is there any way to get XIRR to work with such an arrangement of dates? I only get errors. -- W |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to work hours backwards | Excel Discussion (Misc queries) | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Can you work this backwards | Excel Discussion (Misc queries) | |||
| How do I calculate dates backwards from a project end date | Excel Worksheet Functions | |||
| How can I get the XIRR funct to work for a positive first number? | Excel Worksheet Functions | |||
Threaded Mode
