Help formula and function: date of return is blank

[martyk62]

I started a new job yesterday and been trying to develop a formula/function that alerts or shows invoices that have been sent for approval and not returned after a 14 day period allowed. The date is in the formaat 15.4.17
The whole mater is complicated by the fact that they use google docs as default programme.
I have taken a bit of the work home to try and find a solution using Excel 2010.

Can anyone assist attached is a sample of the docs.
I have attached a similar doc.

Many thanks

[TMS]

15.4.17 is not a format that Excel will recognise as a valid date.

You could add 3 helper columns and use the formula

Please Login or Register  to view this content.

copied across and down.

Then use those real dates for your date comparison(s).

[martyk62]

Thanks a lot spent the day changing the date format and once done will use formula.
Thanks once again. Is there a of changing the date format easily from 15.5.17 format to 15/05/17

[martyk62]

15.4.17 is not a format that Excel will recognise as a valid date.

You could add 3 helper columns and use the formula

Please Login or Register  to view this content.

copied across and down.

Then use those real dates for your date comparison(s).

Thanks TMS I have changed the date format to 15/05/2017 which the same as on my compter yet I am getting a VALUE error as below.
Capture1.PNG

[JeteMc]

Perhaps the following formula will work for you:

Please Login or Register  to view this content.

- Select cell J2 and paste the formula into the formula bar,
- After pressing the enter key, drag fill handle of J2 over to L2,
- With J2:L2 still selected drag the fill handle of L2 down to L10.
At this point you could copy J2:L10 and paste back into the original range as value (change the format of F2:H10 to date).
Let us know if you have any questions.