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