Document Tracking & Management

M
Matt Gaunt 👤 Member for 18 years 7 months
S
Samer Zawaydeh 👤 Member for 17 years 10 months

Dear Matt,



In addition to the good remarks, I would recommend that you search amazon.com and get a copy of the Excel teaching book. I saw it a few years ago and it was really excellent.

And I think it is below $30.



With kind regards,



Samer

K
Kumaraganesan K 👤 Member for 19 years 1 month

Hai



I am using Excel for Engineering Document Tracking. Please use Conditional formatting on the cell where the plan date for each document is mentioned. When you update the cell for Status date, the plan date should appear as "RED" or preferable color. It is easy to track the overdue dates.

M
Mike Testro 👤 Member for 20 years 5 months

Hi Matt



I am not an excell user - I prefer Lotus 123 - but it seems that you have a relatively simple set of data that needs a "what if" formula to check if a particular date is later than one which is specified.



Even excell can do this.



Have a look at the =if(etc) probabilities.



Best regards



Mike Testro.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts