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
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityHow 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
Please use the following formula
=SEQUENCE(COUNT(B5:B),1,DATE(A2,MONTH(A1&1),1),1)
You then format your cells as Tue
found under Format
>Number
>More date and time formats
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)