View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kamran Kamran is offline
external usenet poster
 
Posts: 19
Default Date change button/macro

Hello,
I use a spreadhseet as a timesheet for work, and every week I have to change
the dates. I use the date in the first cell (for Monday) and the others just
calculate "+1". What kind of a macro can I assign to a button that I can
just click to add 7 to the Monday date?
Thanks,
Kamran