Today minus 1 day

What is the formula for current date, minus one day?

Thank you so much!
--
MB

Try this:

=TODAY()-1

Remember to format the result as a date.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MB" wrote:

> What is the formula for current date, minus one day?
>
> Thank you so much!
> --
> MB

=Today()-1

"MB" wrote:

> What is the formula for current date, minus one day?
>
> Thank you so much!
> --
> MB

duh. (!) As soon as I saw your answer, I felt really silly. Thank you SO
much!
--
MB


"Ron Coderre" wrote:

> Try this:
>
> =TODAY()-1
>
> Remember to format the result as a date.
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "MB" wrote:
>
> > What is the formula for current date, minus one day?
> >
> > Thank you so much!
> > --
> > MB