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

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

Using formula to find out a Date 90 prior to a particular date
 

Are you sure you mean that, Per?
DAY(90) is 30, as the number 90 is Excel's representation of 30 March 1900.

Don't you just want =B2-90 ?
--
David Biddulph

"Per Jessen" wrote in message
...
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