Alert date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=IF(TODAY()<=Sheet1!C3,IF(Sheet1!C3-TODAY()<=30,"Due",""),"Past Due")

HTH
Kostis Vezerides
 
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 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...
 
IN Sheet2, cell C4, put this formula

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

Vaya con Dios,
Chuck, CABGx3
 
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...
 
You're welcome...........sorry for the multi-posts........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula questions 3
I need a cell to be blank. 4
Need help with this formula 1
DBSUM function but with function as criterion, not a range 3
Index match with multiple criteria(different than usual) 3
Macro Copy Worksheet Name into worksheet A1 3
compare data in 2 worksheets 1
Assign values to text within a cell 2

Back
Top