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 . . .
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 . . .
What is a spinner box?
"Mrebisz3154" <[email protected]> wrote in message
news:[email protected]...
>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 . . .
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" <[email protected]> wrote in message
news:[email protected]...
> 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 . . .
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 . . .
>
>
>
Glad to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mrebisz3154" <[email protected]> wrote in message
news:[email protected]...
> Thanks it Worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks