=IF(AND(NOT(ISBLANK(

KarineMul22_TPg

Hi,

I am trying to write a formula saying:

• If Forecasted Line Delivery is populated, then apply WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row, 0
• if Forecasted Date is Blank, then copy the value from the cell above

My latest attempt looked like this =IF(NOT(ISBLANK([Forecast Line Delivery]@row, WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row, 0), VALUE([Days between Due Date and Forecasted Delivery Date]56)))), which is obviously not correct

Would welcome any help, many thanks

Mark.poole

Try

=if([Forecast Line Delivery]@row<>"",WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row,0),VALUE([Days between Due Date and Forecasted Delivery Date]56))