| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic rolling months for forecast sheet
I have to make a sales forecast sheet with rolling months, so that when sales
type "Aug-07" at A1, A2 becomes "Sep-07", and A3 becomes "Oct-07" and so on... However, i am not sure will the salesman type "Aug-07" or "August-07" or 08012007" at A1... Besides, i want the month (and the rolling months) a REAL DATE format because i will copy it to Access database for statistic purpose. How to make this happen, please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| template of a rolling forecast for production? | Excel Worksheet Functions | |||
| ROLLING 12 MONTHS PLEASE HELP ME!!!!! | Excel Discussion (Misc queries) | |||
| Rolling Forecast | Excel Worksheet Functions | |||
| I look for templates to plan rolling forecast allocation | Excel Discussion (Misc queries) | |||
| how do I forecast a 15% increase over 7 months? | Excel Discussion (Misc queries) | |||
Threaded Mode
