calculate back dates
in [General]
|
From: sonia on 22 Mar 2010 22:29 Hi is there a way to figure out a date 9 months previous to a date? eg. I have an install date of 12/02/10, is there a way or a formula that can count back 9 months from that install date? (they need to be weekdays) thanks very much
From: Fred Smith on 22 Mar 2010 22:35 Just use the Date function, as in: =Date(year(a1),month(a1)-9,day(a1)) Regards, Fred "sonia" <sonia(a)discussions.microsoft.com> wrote in message news:63DDCF12-C093-4532-B71C-2FB9112A47B8(a)microsoft.com... > Hi > > is there a way to figure out a date 9 months previous to a date? > > eg. I have an install date of 12/02/10, is there a way or a formula that > can > count back 9 months from that install date? (they need to be weekdays) > > thanks very much
From: Alejandro Medinilla "elMedex" on 22 Mar 2010 22:50 ty this one =IF(MONTH(A1)>=9,DATE(YEAR(A1),MONTH(A1)-9,DAY(A1)),DATE(YEAR(A1),MONTH(A1)-9,DAY(A1))) please reply if the post is helpfull regrads elMedex "sonia" wrote: > Hi > > is there a way to figure out a date 9 months previous to a date? > > eg. I have an install date of 12/02/10, is there a way or a formula that can > count back 9 months from that install date? (they need to be weekdays) > > thanks very much
From: Alejandro Medinilla "elMedex" on 22 Mar 2010 22:53 sorry this is the one is easier =DATE(YEAR(A1),MONTH(A1)-9,DAY(A1)) the other was a test but is redundant "Alejandro Medinilla "elMedex"" wrote: > ty this one > > =IF(MONTH(A1)>=9,DATE(YEAR(A1),MONTH(A1)-9,DAY(A1)),DATE(YEAR(A1),MONTH(A1)-9,DAY(A1))) > > please reply if the post is helpfull > > regrads > > elMedex > > "sonia" wrote: > > > Hi > > > > is there a way to figure out a date 9 months previous to a date? > > > > eg. I have an install date of 12/02/10, is there a way or a formula that can > > count back 9 months from that install date? (they need to be weekdays) > > > > thanks very much
From: sonia on 23 Mar 2010 00:10
Hi I'm getting a #VALUE! error, everytime I try it. I put the formulas in the way explained, but I changed A1 to the cell that i have the install date in, (as i would change the cell to all the different install dates, there isn;'t just one install date, there are many. ANy ideas on this problem?? "sonia" wrote: > Hi > > is there a way to figure out a date 9 months previous to a date? > > eg. I have an install date of 12/02/10, is there a way or a formula that can > count back 9 months from that install date? (they need to be weekdays) > > thanks very much |