RHurlburt
03-26-2005, 02:13 PM
I have a need for "IF" using the values in cells which are in date format. These date values are the result of formulae OR values in another workbook. I have the need to write something like:
=IF((Date1=Date2),T (a formula here),F (a different formula here)).
The values are in, as an example, T12 and V9. The format of the "visible" cells are "mmm-yy". (Many cells will end up being used with this formula)
As a starter, I looked at
=IF(TEXT(A1,"ddd")="Sat","Yes","No")
But that is for text and I am using date. And, the above is incomplete for what I want to do.
And, I can't use VBA at to do this particular .
Will I need some sort of "COMPARE" and then the IF?
Thanks!!
I tried:
=IF(EXACT(T12,V9),"T","F")
and received "F", even tho the cells display the same "Jun=06".
SOLVED.
I changed the format to General and noticed that the number was different:
38533 to 38532. June 30, 2006 vs June 29, 2006. I change my formula to calculate the June 30 date, and now my IF formula works perfectly.
"What a difference a day makes." <g>
Richard
=IF((Date1=Date2),T (a formula here),F (a different formula here)).
The values are in, as an example, T12 and V9. The format of the "visible" cells are "mmm-yy". (Many cells will end up being used with this formula)
As a starter, I looked at
=IF(TEXT(A1,"ddd")="Sat","Yes","No")
But that is for text and I am using date. And, the above is incomplete for what I want to do.
And, I can't use VBA at to do this particular .
Will I need some sort of "COMPARE" and then the IF?
Thanks!!
I tried:
=IF(EXACT(T12,V9),"T","F")
and received "F", even tho the cells display the same "Jun=06".
SOLVED.
I changed the format to General and noticed that the number was different:
38533 to 38532. June 30, 2006 vs June 29, 2006. I change my formula to calculate the June 30 date, and now my IF formula works perfectly.
"What a difference a day makes." <g>
Richard