Excel table in the date of the auto show Saturdays and Sundays
I visit each table shows the date:October 30, 2008, a few weeks rather than years.But I also want me to the table time and time synchronization of computers, each encounter is on Saturdays, Sundays When the date is automatically labeled, for example, on Saturdays and Sundays on the date indicated in red.
And when a month later to automatically generate the forms of the month.And to form a Exactly the same.
Selected data (for example, A1:A10) – format – the format conditions, the conditions of an option “formula” Behind the importation of:= OR (WEEKDAY (A1, 2) = 6, WEEKDAY (A1, 2) = 7), (If you choose the data in the region A2:A10, then:= OR (WEEKDAY (A1, 2) = 6 , WEEKDAY (A1, 2) = 7)) (available ctrl + V to paste) point format button and selecting a format to determine.
Leave a Reply
You must be logged in to post a comment.