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

Hi Vinrod

With your date in B2, this will do it:

=B2-DAY(90)

Regards,
Per

"Vinod" skrev i meddelelsen
...
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