Alert date
 

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

Alert date
 

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

HTH
Kostis Vezerides


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

Alert date
 

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

Alert date
 

"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

Alert date
 

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

Alert date
 

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

Alert date
 

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