holymoly
Thread Starter
 Joined
 Jun 21, 2003
 Messages
 635
I currently have a formula that takes the current day, and compares to an Order Picked date.
The formula calculates is the difference between the dates is more than 2.5, "Overdue" is returned in the cell
The problem I encounter is on Mondays and Tuesdays, where I need to change the formula manually to 4.5 and 3.5
because the Sat and Sunday are not skipped and no orders are sent as those are off days. So an order picked on Friday
would show as Overdue on Monday as it is more than 2.5 days.
Original Formula : =IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))
The new Formula: =IF(AND($D$3=Monday,A2+4.5<$C$3),Overdue, IF(AND($D$3=Tuesday,A2+3.5<$C$3),Overdue, IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))))
has not worked. Perhaps wrongly positioned parenthesis? It returns #NAME#
A sample spreadsheet is attached.
The formula calculates is the difference between the dates is more than 2.5, "Overdue" is returned in the cell
The problem I encounter is on Mondays and Tuesdays, where I need to change the formula manually to 4.5 and 3.5
because the Sat and Sunday are not skipped and no orders are sent as those are off days. So an order picked on Friday
would show as Overdue on Monday as it is more than 2.5 days.
Original Formula : =IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))
The new Formula: =IF(AND($D$3=Monday,A2+4.5<$C$3),Overdue, IF(AND($D$3=Tuesday,A2+3.5<$C$3),Overdue, IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))))
has not worked. Perhaps wrongly positioned parenthesis? It returns #NAME#
A sample spreadsheet is attached.
Attachments

10.3 KB Views: 45