Apr 26 2023 10:18 AM
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
cheers
dave
dave
Apr 26 2023 10:36 AM
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, ...
Apr 26 2023 10:42 AM
Apr 26 2023 11:28 AM