Excel Formula Help

[News Bot]

Hi Guys,

not sure whether anyone can help with this but i will try anyway, i have created a spreadsheet as per below:

 

 

 

 

Ticket Number

Work awaiting

Original Due Date

Status

 

 

 

2758

HLE

07/06/2012

8.00

Days

 

 

2498

HLE

31/05/2012

1.00

Days

 

 

2845

HLE

28/05/2012

-2.00

Days

 

 

 

 

the columns are A,B,C,D. The Status coloumn needs to be able to calculate the difference between todays date and the due date, the Status coloumn needs to show the amount of days remaining and a minus if its overdue but also if the Status is 4 days or more

away the cell is filled green, if it is 1-3 days away the cell needs to fill Amber and if it is 0 or a minus amount of days it needs to fill the cell Red, but you still need to see the information.

 

any ideas guys?

 

Thanks Brad

 

View this thread