Unable to get date to flag "late" in macro

[rgleeso1]

I had a spreadsheet developed for me at work but the lad who developed it for me has subsequently left and I'll be honest I would not have any idea of macro's or some executables in excel. The only problem I'm having with this is it is not flagging item's as late unless they have gone over 2 months past the target date (would be ideally looking for 1 day past target date for it to flag late). Could anyone just have a quick look at this, I'm sure that this could be a quick fix but I would not have the relevant expertise for this. If someone can rectify the problem could you also just give me a quick explaination as to how this was done as I would like to have an idea myself and not have to continue to bug people with simple problems like this.

Thanks in advance for your help,
Rob

Oh I've attached a copy of the excel spreadsheet in 2007 format

[DonkeyOte]

This file links to data contained in another file (Work Matrix 2.xlsm) which would appear to drive Column H ... there is nothing in the code that affects the Flag (or at least nothing that I could see)... so in short we need to see the source file.

That said I'm not sure why you need the links... ?

[rgleeso1]

ok, yeah I'm simple. I automatically thought it was a macro error (do to the file containing macro's) and I never checked the excel formula, thanks for your help DonkeyOte. All I did was remove reference to the out-source link and everything is working perfectly fine now. Thanks again

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save