|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 15th, 2009, 10:18 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
June 15th, 2009, 10:29 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
June 15th, 2009, 12:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
