What I would like to do is create an IF statenent contingent upon the YEAR which is with in a date, the month and date are really have no concern.
Either D or E (or both) will have a date within the cell.
So far this is what I have BUT I know its wrong after E3=
IF(D3+OR(E3=DATE(YEAR(1991),"",1))))
tks gg
Either D or E (or both) will have a date within the cell.
So far this is what I have BUT I know its wrong after E3=
IF(D3+OR(E3=DATE(YEAR(1991),"",1))))
tks gg