Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date flexibility
I am trying to build a model that allows me to move start dates of
various projects easily - these projects then feed into a consolidated set of cash flows. I want to then run sensitivities around the start dates - so they need to be flexible. Can anyone suggest an easy way to set this up? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date flexibility
On Jul 15, 11:29 am, Karina wrote:
I am trying to build a model that allows me to move start dates of various projects easily - these projects then feed into a consolidated set of cash flows. I want to then run sensitivities around the start dates - so they need to be flexible. Can anyone suggest an easy way to set this up? Well, you can designate a cell for your start date. Then you can change it if you feel like it. Is that flexible enough? If you had a short list of possible start dates you could give the cell a drop-down with just those dates in it to avoid typos when you want to switch. Or you could make several instances of the same calculation for easy comparison, with a different date on each one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Can you build a formula in one cell with flexibility | Excel Discussion (Misc queries) | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Add flexibility to Criteria of DFunctions | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |