Thanks.

The second formula works even better.

"Max" wrote:

Think what was suggested earlier by Gary's Student should work.
Give it another go.

Try in H31, and copy down
: =IF(Y31="",TODAY()-W31,"")

If you want to check for "nothing" in col W as well,
then one way is to put it in H31 as:
=IF(OR(Y31<"",W31=""),"",TODAY()-W31)
and copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--