Ravi Sir's Cards › Excel
Sleep Tracker in Excel (card 1 of 2)
Revision card 1 for Sleep Tracker in Excel: Weekday name: =TEXT(A6,"ddd") gives Thu; Next date: =A6+1 gives 02-10-2026; Weekday or Weekend: =IF(WEEKDAY(A6,2)>5,"Weekend","Weekday") gives Weekday. Includes an example data table.
Read card text
What this card says
1 for Sleep Tracker in Excel: Weekday name: =TEXT(A6,"ddd") gives Thu
Next date: =A6+1 gives 02-10-2026
Weekday or Weekend: =IF(WEEKDAY(A6,2)>5,"Weekend","Weekday") gives Weekday. Includes an
Example
data table
Learn this in the lesson: Sleep Tracker in Excel: Calculate Hours Slept (Even Past Midnight) and Weekly Averages