Hi all,
Grateful for some advice on a function I'm struggling to conquer.
I have Cell A2 displaying a reference number (this starts with either MCxxxx or TOxxxx). In G2 a received date is entered and in H2 I need the function to add either 5 Working days to the G2 date if "MC' has been entered into A2. Or add 7 working days to the G2 date if "TO" has been entered into A2. If there is no reference in A2 or no date entered in G2 then no result shown in H2....
Hope that makes sense!
Hope someone can offer a solution. Struggling with the IF/OR function I'm currently trialing.
Than
Bookmarks