View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Finding a Date 90 days previous to present date

With date in A1 the below formula will do.

=A1-90
(and format this to date)

If this post helps click Yes
---------------
Jacob Skaria


"Vinod" wrote:

Pls help me in executing a date 90 days before a present date.
eg:Format of the file

Present Date days before previous date
15/06/2009 90 ?

Hope you understood my question.