In Google Sheets, I have two columns, date and day, when date is entered i want day to be filled automatically,
For example, if you set A1 as 1/12/21 then day cell should change to Wednesday.
How do we do that?
Asked
Active
Viewed 328 times
-1
Iamblichus
- 18,540
- 2
- 11
- 27
Zil Sanghvi
- 74
- 10
-
@carlesgg97 Kindly check sir – Zil Sanghvi Nov 29 '21 at 05:00
-
What does `day` refer to here? Day of the month? – Iamblichus Nov 30 '21 at 10:19
-
Yes, if you set A1 as 1/12/21 then day cell should change to wednesday – Zil Sanghvi Nov 30 '21 at 18:15
2 Answers
2
Use TEXT to convert your date to the desired format, where:
dddd for the full name of the day of the week.
=ARRAYFORMULA(IF(A2:A="",,TEXT(A2:A,"dddd")))
Iamblichus
- 18,540
- 2
- 11
- 27
1
Assuming the dates are in A2:A, put this formula in B2:
=ArrayFormula(IF(A2:A="",,DAY(A2:A)))
idfurw
- 5,727
- 2
- 5
- 18
-
Its returning date, if A2 is 30/11/21 then with this formula its showing 30 as result i want Tuesday as answer. – Zil Sanghvi Nov 30 '21 at 18:16