Returning Yesterday

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bollard - 12 May 2008 16:05 GMT

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

Reply to this Message

Teethless mama - 12 May 2008 16:11 GMT

=TODAY()-1

> Hello
>
[quoted text clipped - 6 lines]
>
> Keith

Reply to this Message

bollard - 12 May 2008 16:30 GMT

Thanks.

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

> =TODAY()-1
>
[quoted text clipped - 8 lines]
> >
> > Keith

Reply to this Message

Reitanos - 12 May 2008 16:11 GMT

How about =TODAY()-1

On May 12, 11:05 am, bollard <boll...@discussions.microsoft.com>
wrote:

> Hello
>
[quoted text clipped - 6 lines]
>
> Keith

Reply to this Message

Max - 12 May 2008 16:12 GMT

This should work: =TODAY()-1

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hello
>
[quoted text clipped - 6 lines]
>
> Keith

Reply to this Message

Sandy Mann - 12 May 2008 16:14 GMT

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

=TODAY()-1

Signature

HTH

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

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

> Hello
>
[quoted text clipped - 6 lines]
>
> Keith

Reply to this Message