Working out due dates and highlighting

[devon247]

Please can anyone help i would like to set a priority within excel and for a due date be calculated (please note i am in the middle east therefore working days are between Sunday to Thursday). My spreadsheet is as follows

Date In - Speed - Due Date - Date Completed STATUS



I should enter date in manually and speed combo box. The Speed will determine the number of working days for example:

Normal = 5 WD
Express = 3 WD
Super = 2 WD

Due Date should be calculated and if it is more than due date then it should turn red (or should show any warning)

Can anyone help i have tried a number of combinations but don't seem to work.

I tried

for due date: =WORKDAY(A10,LOOKUP(F10,{"Normal","Express","Super"},{4,3,2}))

Late warning: =IF(I10>G10,"LATE"," ")

Status =IF(I1>=G10,"OVERDUE",IF(I1<G10," "))

[Brendan_Floyde]

You'll want to have a look at this function

https://support.office.microsoft.com...rs=en-GB&ad=GB

[Brendan_Floyde]

See attached example.

[devon247]

Wanted to thank you, worked perfect and you responded quickly, thanks a million!

[Brendan_Floyde]

To mark your thread solved do the following:

-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

If I helped please consider * add reputation

ta
bren

[devon247]

How do i hide the #N/A if the start date is empty within the same formula?