make monday tuesday automatic

Question

hey lovely peopleI 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 etcwhat is the formula if i change Monday to Friday how do i make all the others change automatically&nbsp;i have attached an example&nbsp;cheers&nbsp;dave&nbsp;dave&nbsp;&nbsp;

hansvogelaar · Answer

appletonthecat&nbsp;
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, ...

appletonthecat · Answer

Hey Hans,thanks for the replyi can't seem to do this bit, I have been to customs but do not have an option for dddd for some reason

hansvogelaar · Answer

appletonthecat&nbsp;
You have to type dddd into the Type box:

Forum Discussion

make monday tuesday automatic

3 Replies

Resources