View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vinod vinod is offline
external usenet poster
 
Posts: 23
Default Using formula to find out a Date 90 prior to a particular date

I am trying to use a formula for finding out a date 90 days before a
particular date.
I used the formula =DATE(2009,9,25-I80) for finding a date that is 90
days before 25/9/2009.
My problem is that I have a column B with the dates get changed on each
entry and and in other column I want to get a date before 90 days.
I mean how to use the formula with the dates getting changed on each entry?
Hope you can help me out.
If req I can send you the file.

Regards
Vinod