Thread: Calcuate 2 days prior to TODAY
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Calcuate 2 days prior to TODAY
On Sun, 19 Jul 2009 09:40:01 -0700, jmsinner
wrote:

How do you calculate 2 days prior to =TODAY()?

=today()-2

--ron
Reply With QuoteReply With Quote