The problem is that when the cell contains "Today" then the YEAR() function
returns a #VALUE! error and causes the formula to error. Since you're just
returning a Boolean you can don't need the IF. Try it like this:

=OR(AS6="TODAY",YEAR(N(AS6))1900)


--
Biff
Microsoft Excel MVP


"Anurag" wrote in message
...
For some reason =IF(OR(AS6="TODAY",YEAR(AS6)1900),TRUE,FALSE) is not
working
together.
AS6 is just one of the cells and I would like the cell to be formatted if
the cell entry is either a date (obviously a recent one) or the word
"Today".
However, if I seperate the two, they work just fine.
Any suggestions?