make monday tuesday automatic

Copper Contributor

hey lovely people

I think I have a simple one but I can't seem to make it work..

if I have Monday in d4 then want Tuesday in e4 Wednesday in f4 etc

what is the formula if i change Monday to Friday how do i make all the others change automatically


i have attached an example









3 Replies


Set the number format of D4 to the custom format dddd.

Enter the formula =E4 in D4.

Copy D4 to F4, H4, J4, L4, N4 and P4.

Then to D20, F20, ...

Hey Hans,

thanks for the reply

i can't seem to do this bit, I have been to customs but do not have an option for dddd for some reason


You have to type dddd into the Type box: