increase date with use of button?

[eHanSolo]

hi there,

i have a date in cell A1 showing: May-06

I'd like to have a few buttons that would increase the date in this cell either by one month at a time or 6 months at a time... any ideas??

(hope you all had a great weekend!)

thanks!

e

 

[xlbo]

well - what have you tried ?

Have you read the FAQ about dates & times in the MSOffice forum ?? faq68-5827 If not, read it, apply it and post back with a specific question

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question