One More on Date Function

  • Thread starter Thread starter Kreiss
  • Start date Start date
K

Kreiss

Everybody that helped me in my previous question was a
great help....thanks!

Now, I have this and it works.....but........

=IF(DATEDIF(RIGHT(A4,10),TODAY(),"Y")=0,"",DATEDIF(RIGHT
(A4,10),TODAY(),"Y")&" "&"year"&" & ")&DATEDIF(RIGHT
(A4,10),TODAY(),"YD")&" "&"days"

I have a spreadsheet for each year. So if it's 2004 and I
look at the 2003 spreadsheet it will give me an inaccurate
number of days for 2003. I'm trying to say if it is >= to
12/31(of the report year)...that's what a2 is, to do the
datedif from right(a4,10) to 12/31/a2. Otherwise if its
not greater than 12/31/a2....to go ahead and do the
datediff using Today(). Below is what I think it should
look like, but still getting an error.

=If (today() >="12/31"&a2,datedif(right(a4,10),"12/31"&a2)
& IF(DATEDIF(RIGHT(A4,10),TODAY(),"Y")=0,"",DATEDIF(RIGHT
(A4,10),TODAY(),"Y")&" "&"year"&" & ")&DATEDIF(RIGHT
(A4,10),TODAY(),"YD")&" "&"days"

Thanks in advance,
Kacy
 
Back
Top