single shots

A spreadsheet formula to convert a date in one column to the weekday (like “Thursday”)?’

You can use the following formula in a spreadsheet cell to convert a date in one column (let’s say it’s in cell A1) to the corresponding weekday (like “Thursday”) in another cell:

`=TEXT(A1, “dddd”)`

This formula will take the date in cell A1 and display the weekday in full text format in the cell where you enter the formula.