Date changes

%3CLINGO-SUB%20id%3D%22lingo-sub-2336168%22%20slang%3D%22en-US%22%3EDate%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2336168%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20show%2Ftrack%20changes%20to%20production%20dates%20listed%20in%20columns%20B-F%20for%20a%20product%20listed%20in%20column%20%E2%80%9CA%E2%80%9D%26nbsp%3B%3C%2FP%3E%3CP%3ECell%20A3-%20A32%20are%20products%20in%20production.%3C%2FP%3E%3CP%3ECells%20B3%3AB32%2C%20F3%3AF32%20are%20weekly%20production%20updates%20in%20short%20date%20format%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2336168%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337845%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048109%22%20target%3D%22_blank%22%3E%40CW1287%3C%2FA%3E%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20using%20Excel%20Online%20the%20you%20can%20take%20the%20advantage%20of%20Show%20Changes%2C%20to%20know%20more%20about%20it%20check%20this%20blog%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fcollaborate-with-confidence-introducing-show-changes-for-excel%2Fba-p%2F2279187%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fcollaborate-with-confidence-introducing-show-changes-for-excel%2Fba-p%2F2279187%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is there a way to show/track changes to production dates listed in columns B-F for a product listed in column “A” 

Cell A3- A32 are products in production.

Cells B3:B32, F3:F32 are weekly production updates in short date format

2 Replies

Hi @CW1287,

 

If you are using Excel Online the you can take the advantage of Show Changes, to know more about it check this blog 

https://techcommunity.microsoft.com/t5/excel-blog/collaborate-with-confidence-introducing-show-chang...

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

 

track one change? or track every time it changes?, automatically no because you need a column with a static date to compare to in order for you to know if it has changed and the only way for you to track each time it has changed is to key it into your production date change.