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

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 at 21:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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