=IF(AH21="u","Complete",IF(AND(R2<TODAY(),R5="")," Overdue","In Progress"))

is that AND correct? < today AND blank, that is just the same as blank.

--
__________________________________
HTH

Bob

"MJS" wrote in message
...
Hey,
I am putting together a task schedule on Excel and struggling to pull
together the formula i require.
Basically i have a formula in place, located in cell B5, to say whether a
task is "overdue" or "In Progress".

=IF((AND(R2<TODAY(),R5="")),"Overdue","In Progress")

However i need an overriding formula, or some way to integrate the below
formula into to original so that when i put a "u" in cell AH21, it changes
cell B5 to "Complete", ignoring "Overdue" and "In progress".

=IF(AH21="u","Complete")

Thanks,

Mike