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

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


--
cstandinguk
------------------------------------------------------------------------
cstandinguk's Profile: http://www.excelforum.com/member.php...o&userid=31685
View this thread: http://www.excelforum.com/showthread...hreadid=513826

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

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 Tuesday


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513826

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

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


--
cstandinguk
------------------------------------------------------------------------
cstandinguk's Profile: http://www.excelforum.com/member.php...o&userid=31685
View this thread: http://www.excelforum.com/showthread...hreadid=513826

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

It's ok, I have sorted it now.

thanks again for your help

Chris


--
cstandinguk
------------------------------------------------------------------------
cstandinguk's Profile: http://www.excelforum.com/member.php...o&userid=31685
View this thread: http://www.excelforum.com/showthread...hreadid=513826