Inserting auto weekly dates

[JulieD]

Hi Marilyn

not sure exactly what you mean by "insert weekly auto dates" but one thing
that might work for you is
assuming Monday's date is in cell B1 and you want Tuesday's date in cell B2,
Wednesday's in cell B3 etc, then you can type the date into cell B1, then in
cell B2 enter the formula =B1+1, copy this down for Wed -> Sun - now all you
have to do each week is type in Monday's date and the rest will change
automatically.

If this isn't what you were after please repost

Regards
JulieD

I'm working on timesheets that go from Monday to Sunday, which changes

weekly. How can I insert weekly auto dates for Monday to sunday?

 

[Guest]

I'm working on timesheets that go from Monday to Sunday, which changes weekly. How can I insert weekly auto dates for Monday to sunday?

 

[Bob Phillips]

Marilyn,

Insert the date for Mon in A1 say, then B1 =A1+1, etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I'm working on timesheets that go from Monday to Sunday, which changes

weekly. How can I insert weekly auto dates for Monday to sunday?

 

[JE McGimpsey]

One way:

Assume Mon-Sun is in B1:H1

B1: =TODAY()-WEEKDAY(TODAY(),3)
C1: =B1 + 1

Copy C1 over to H1