Alert date

B

Bill

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
 
V

vezerid

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

HTH
Kostis Vezerides
 
C

CLR

In Sheet2 cell C4, put this formula

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

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Bill said:
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
Click to expand...
 
C

CLR

IN Sheet2, cell C4, put this formula

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

Vaya con Dios,
Chuck, CABGx3
 
B

Bill

Thanks, Very Much
--
Bill


CLR said:
IN Sheet2, cell C4, put this formula

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

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top