You're welcome...........sorry for the multi-posts........

Vaya con Dios,
Chuck, CABGx3


"Bill" wrote in message
...
Thanks, Very Much
--
Bill


"CLR" wrote:

IN Sheet2, cell C4, put this formula

=IF(TODAY()Sheet1!C3,"Past due",IF(TODAY()Sheet1!C3-30,"Due",""))

Vaya con Dios,
Chuck, CABGx3



"Bill" wrote:

I got a Due date in Worksheet1 C3 and in worksheet2 C4 I would like it
to
give me(Due) 30days before Worksheet1 C3 and (Past Due) after
Worksheet1 C3
--
Bill