Forum Discussion
make monday tuesday automatic
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...
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
