David123456
New Member
- Joined
- Jul 16, 2014
- Messages
- 48
=IF('Tender 1'!D4="Tender",'Tender 1'!D30-'Tender 1'!A1<7,"7 Day chase up required")
All,
I need a formula to do the following:
On Sheet Tender 1 - Cell D4 will have two options - Either Liver Job or Tender
On Sheet Tender 1 - Cell D28 a date to chase has been generated:
If its a tender chase in 35 days
If its a Live Job chase in 5 days
On Sheet Tender 1 - Cell A1 I have the =Today()
Could I use Dated IF
I would like a WARNING Flag once the date between Cell A1 and Cell l28 dependant on scenarios - ie Tender or Live Job is breached.
All,
I need a formula to do the following:
On Sheet Tender 1 - Cell D4 will have two options - Either Liver Job or Tender
On Sheet Tender 1 - Cell D28 a date to chase has been generated:
If its a tender chase in 35 days
If its a Live Job chase in 5 days
On Sheet Tender 1 - Cell A1 I have the =Today()
Could I use Dated IF
I would like a WARNING Flag once the date between Cell A1 and Cell l28 dependant on scenarios - ie Tender or Live Job is breached.