is it possible for a cell to change a date every 7 days ??

C

cstandinguk

Hi.

I am working on a spreadsheet for work. The problem is i have a
vertical list of 4 dates each one 7 days in front of the other
(consecutive weeks).

Is it possible to automate the dates so they automatically update to
show the next 7th day, every 7 days ?

Sorry if this sounds confusing. Any help is greatly appreciated as I am
something of a novice!

Many Thanks

Chris
 
D

daddylonglegs

What days do you want to show and when should they change?

You could adapt something like this

A1

=TODAY()+7-WEEKDAY(TODAY()-2)

A2

=A1+7

copied down to A4

A1:A4 now shows the next four Mondays (including today if a Monday)
it'll change on a Tuesda
 
C

cstandinguk

thanks for your help, much appreciated.

Sorry, my original posting wasn't clear.

I am creating a booking system for work. I need the date shown to be
the week commencing Monday of every week.

I am having trouble adapting your code. (I did say I was a
novice:rolleyes: )

Cheers

Chris
 
Top