Returning Yesterday
 

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

Returning Yesterday
 

=TODAY()-1

"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

Returning Yesterday
 

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

Returning Yesterday
 

This should work: =TODAY()-1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

Returning Yesterday
 

It is possible to embed the TODAY() function in a formula:

=TODAY()-1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"bollard" wrote in message
...
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

Returning Yesterday
 

Thanks.

I didn't think that formula worked. I thought I'd tried it, but I'll give it
another go.

"Teethless mama" wrote:

=TODAY()-1

"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