Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date formats
Hi,
I am making a 12 month column report. I want the user to able to chose up to which month actaul data will be retrieved and going forward budgeted data. Can somebody help me with this? -- Paul P |
#2
|
|||
|
|||
=MONTH(TODAY())
gets the month of today's date, and you can use that as your column offset -- HTH RP (remove nothere from the email address if mailing direct) "Penco Excel User" wrote in message ... Hi, I am making a 12 month column report. I want the user to able to chose up to which month actaul data will be retrieved and going forward budgeted data. Can somebody help me with this? -- Paul P |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |