1

enter image description here

How can I fill-in column A, make it start with the day's name according to the year in A2 and month in A1 and conditionally format them?

https://docs.google.com/spreadsheets/d/1Dvi7FKZwz14Taivt5fJNqDxcQGFJb1jrS5kqJdbzYXw/edit?usp=sharing

1 Answer 1

1

Please use the following formula

=SEQUENCE(COUNT(B5:B),1,DATE(A2,MONTH(A1&1),1),1)

enter image description here

You then format your cells as Tue found under Format >Number >More date and time formats

enter image description here

I also noticed that you have the following conditional formatting applied, which will no longer work

=OR($A5="Fri",$A5="Sat")

What you should now use is

=OR(WEEKDAY($A5)=6,WEEKDAY($A5)=7)

1
  • 1
    Thanks a lot for your help. I really learned quickly with your tricks and ideas Feb 19, 2021 at 21:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.