How about =TODAY()-1

On May 12, 11:05 am, bollard
wrote:
Hello

I want my spreadsheet to return YESTERDAY's date, not TODAY's.

I believe it's not possible to embed TODAY() in a formula, so can anyone
tell me how to return YESTERDAY'S date into a cell?

Thank you.

Keith