Incrementing Days by one step at a time

  • Thread starter Thread starter Aidan
  • Start date Start date
A

Aidan

I am trying to to increment days by one after 4 entries.
Starting with 'Monday' in cell A1, and then cells A2 to A3
have the formula ' =A1 '.

The problem is, if I change A1 to Wednesday, I want A6 to
automatically change to Thursday.

i.e.

A1: Monday
A2: Monday
A3: Monday
A4: Monday
A5: (blank)
A6: Tuesday
A7: Tuesday
A8: Tues...
 
a6: =A1+1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
enter the following in A2
=IF(MOD(ROW(),5)=0,"",$A$1+INT((ROW()-1)/5))
and copy down
 
Back
Top