Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spinner box in Excel to adjust date
I am trying to get a spinner box in excel to change a date, starting in the
year 2006 and increasing by seven days for the next year. Whenever I set it to do this, it reverts my 2006 date back to 1982 and won't increase, just decrease. Help . . . |
#2
|
|||
|
|||
Spinner box in Excel to adjust date
What is a spinner box?
"Mrebisz3154" wrote in message ... I am trying to get a spinner box in excel to change a date, starting in the year 2006 and increasing by seven days for the next year. Whenever I set it to do this, it reverts my 2006 date back to 1982 and won't increase, just decrease. Help . . . |
#3
|
|||
|
|||
Spinner box in Excel to adjust date
Assuming you mean the spinner from the forms toolbar,
try tinkering something these lines .. Draw a spinner on the sheet, right-click format control Set the cell link to: B1, click OK Enter a start date into C1: 01-Jan-2006 Put in A1: =C1+B1*7 Now when we click the spinner, the date in A1 will advance by 7 days per click And if we want it to increment by 1 day per click, just adjust the formula in A1 to: =C1+B1 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Mrebisz3154" wrote in message ... I am trying to get a spinner box in excel to change a date, starting in the year 2006 and increasing by seven days for the next year. Whenever I set it to do this, it reverts my 2006 date back to 1982 and won't increase, just decrease. Help . . . |
#4
|
|||
|
|||
Spinner box in Excel to adjust date
Thanks it Worked!
"Max" wrote: Assuming you mean the spinner from the forms toolbar, try tinkering something these lines .. Draw a spinner on the sheet, right-click format control Set the cell link to: B1, click OK Enter a start date into C1: 01-Jan-2006 Put in A1: =C1+B1*7 Now when we click the spinner, the date in A1 will advance by 7 days per click And if we want it to increment by 1 day per click, just adjust the formula in A1 to: =C1+B1 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Mrebisz3154" wrote in message ... I am trying to get a spinner box in excel to change a date, starting in the year 2006 and increasing by seven days for the next year. Whenever I set it to do this, it reverts my 2006 date back to 1982 and won't increase, just decrease. Help . . . |
#5
|
|||
|
|||
Spinner box in Excel to adjust date
Glad to hear that !
Thanks for the feedback .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Mrebisz3154" wrote in message ... Thanks it Worked! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Excel formula with date constraints | Excel Discussion (Misc queries) |