Kamran, Try using the following Worksheet function:
=IF(WEEKDAY(TODAY())=2,TODAY(),IF(WEEKDAY(TODAY()) <2,TODAY()+1,TODAY()-WEEKDAY(TODAY())+2))
It should update everytime you open excel
--
Charles Chickering

"A good example is twice the value of good advice."


"Kamran" wrote:

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