Next Delivery Slote Date Required

[ExcelRoy]

Hi,

I am trying to calculate a delivery slot from a date given in N11 or M11 if N11 is blank

The delivery slots would be only weekday Tuesday or Friday

many thanks for any help

 

[PCL]

Is it the next first Tuesday or Friday following the date ?

 

[PCL]

If yes to previous comment ... try

=N11+MIN((IF(5-(WEEKDAY(IF(N11 = "";M11;N11);2))<0;7+5-(WEEKDAY(IF(N11 = "";M11;N11);2));5-(WEEKDAY(IF(N11 = "";M11;N11);2))));(IF(2-(WEEKDAY(IF(N11 = "";M11;N11);2))<0;7+2-(WEEKDAY(IF(N11 = "";M11;N11);2));2-(WEEKDAY(IF(N11 = "";M11;N11);2)))))

 

[ExcelRoy]

Hi PCL,

Thanks for the help but it seems to throw an error?

it highlights the first double quotes as the issue?

 

[PCL]

It seems that the formula separator in your Excel is the comma
Change all ; to ,

 

[ExcelRoy]

Hi PCL,

Many thanks got it working but it doesn't show a valid date for an entry in M11?

Thanks

 

[PCL]

" it doesn't show a valid date for an entry in M11?"
When N11 is empty is it ?

 

[PCL]

YEs a msitake in the final rush: See beginning of next formula


=IF(N11 = "";M11;N11)+MIN((IF(5-(WEEKDAY(IF(N11 = "";M11;N11);2))<0;7+5-(WEEKDAY(IF(N11 = "";M11;N11);2));5-(WEEKDAY(IF(N11 = "";M11;N11);2))));(IF(2-(WEEKDAY(IF(N11 = "";M11;N11);2))<0;7+2-(WEEKDAY(IF(N11 = "";M11;N11);2));2-(WEEKDAY(IF(N11 = "";M11;N11);2)))))