View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default Finding a Date 90 days previous to present date

If you want the date to go in cell C2 the formula would be:

=A2-B2

Then check that the cell is formatted as a date.


"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.