KEMBAR78
A Fortnight Ago: Friday, December 6, 2019 | PDF | Leisure | Sports
Scribd
Upload
49 views3 pages

A Fortnight Ago: Friday, December 6, 2019

The document provides instructions for formatting dates in an Excel spreadsheet. It instructs the user to enter today's date in cell B22 and drag the formula to autofill dates from B8:B25. It then describes how to highlight Sundays in green, yesterdays date in yellow, today's date in red, and the last week in orange. The formatted dates should match the example screenshot provided.

Uploaded by

Rajat Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
49 views3 pages

A Fortnight Ago: Friday, December 6, 2019

The document provides instructions for formatting dates in an Excel spreadsheet. It instructs the user to enter today's date in cell B22 and drag the formula to autofill dates from B8:B25. It then describes how to highlight Sundays in green, yesterdays date in yellow, today's date in red, and the last week in orange. The formatted dates should match the example screenshot provided.

Uploaded by

Rajat Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

In the below example, using Excel function enter todays date in B22 and drag the function above

and below
Saturday, November
Enter todays date in cell B23
Sunday, November
The dates should be filled from B8:B25
Highlight the given dates by applying given conditions Monday, November
The end result should be similar to screenshot provided Tuesday, November
Hint : You might need =TEXT Function to highlight the Sunday Wednesday, November
Thursday, November
Friday, November
A Fortnight ago Saturday, November
Sunday, Decembe
Monday, Decembe
Tuesday, Decembe
Wednesday, Decembe
Thursday, Decembe
Friday, Decembe
Saturday, Decembe
Sunday, Decembe
Monday, Decembe
Tuesday, December
Wednesday, December
Yesterday
Thursday, December
Today's Date Saturday, April 04, 2020 Saturday 6
Friday, December
Tomorrow Sunday, April 05, 2020 Sunday 7
Saturday, December
Monday, April 06, 2020 Monday 1
Tuesday, April 07, 2020 Tuesday 2 Sunday, December
Wednesday, April 08, 2020 Wednesday 3 Monday, December
Thursday, April 09, 2020 Thursday 4 Tuesday, December
Friday, April 10, 2020 Friday 5 Wednesday, December
Saturday, April 11, 2020 Saturday 6 Thursday, December
Sunday, April 12, 2020 Sunday 7 Friday, December
Monday, April 13, 2020 Monday 1 Saturday, December
Tuesday, April 14, 2020 Tuesday 2 Sunday, December
Wednesday, April 15, 2020 Wednesday 3 Monday, December
Thursday, April 16, 2020 Thursday 4
Friday, April 17, 2020 Friday 5
Saturday, April 18, 2020 Saturday 6
Sunday, April 19, 2020 Sunday 7
Monday, April 20, 2020 Monday 1
Tuesday, April 21, 2020 Tuesday 2
Wednesday, April 22, 2020 Wednesday 3
Conditions
Saturday, November 23, 2019
Sunday, November 24, 2019
Sundays in green color
Monday, November 25, 2019
Tuesday, November 26, 2019 The last week should be in Orange
Wednesday, November 27, 2019
Thursday, November 28, 2019
Friday, November 29, 2019
Saturday, November 30, 2019
Sunday, December 1, 2019
Monday, December 2, 2019
Tuesday, December 3, 2019
Wednesday, December 4, 2019
Thursday, December 5, 2019
Friday, December 6, 2019 Yesterday date in Yellow color
Saturday, December 7, 2019 Today in Red Color
Sunday, December 8, 2019
Monday, December 9, 2019
Tuesday, December 10, 2019
Wednesday, December 11, 2019
Thursday, December 12, 2019
Friday, December 13, 2019
Saturday, December 14, 2019
Sunday, December 15, 2019
Monday, December 16, 2019
Tuesday, December 17, 2019
Wednesday, December 18, 2019
Thursday, December 19, 2019
Friday, December 20, 2019
Saturday, December 21, 2019
Sunday, December 22, 2019
Monday, December 23, 2019
name- Rajat Gupta

You might also like