Home

Help with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-728564%22%20slang%3D%22en-US%22%3EHelp%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728564%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3CBR%20%2F%3ECan%20you%20help%20me%20with%20something%20%3F%3CBR%20%2F%3Ei%20want%20to%20compare%202%20calendar%20dates%20in%20excel%20%2C%20for%20example%3A%3CBR%20%2F%3EDATE%201%20-%20DATE%202%3CBR%20%2F%3E10%2F3%2F2017--2%2F6%2F2020%3CBR%20%2F%3E1%2F17%2F2019--1%2F17%2F2020%3CBR%20%2F%3E9%2F25%2F2017--1%2F25%2F2019%3CBR%20%2F%3E3%2F21%2F2018--3%2F21%2F2019%3CBR%20%2F%3Eas%20some%20of%20the%20days%20have%20been%20done%20in%20the%20past%20I%20would%20need%20to%20compare%20the%20dates%20between%20themselves%20and%20between%20%22today%22's%20date%20to%20have%20am%20update%20of%20the%20process%20any%20time%20%3Bas%20this%20dates%20represent%20completion%20days%20of%20our%20colleagues%20training.%3CBR%20%2F%3EDATE%201%20is%20the%20date%20when%20the%20training%20has%20been%20completed%3CBR%20%2F%3EDATE%202%20is%20the%20due%20date%20for%20the%20next%20training%3CBR%20%2F%3EIf%20the%20date%20is%20DATE%202%20%26lt%3B%20TODAY%20by%203%20moths%20range%20it%20will%20be%20highlighted%20with%20red%3CBR%20%2F%3Eif%20the%20date%20is%20DATE%202%26lt%3B%3D%20%2F%3D%26gt%3B%20TODAY%20it%20will%20be%20highlighted%20with%20amber%2Fyellow%3CBR%20%2F%3Eif%20the%20date%20is%20DATE%202%20%26gt%3B%20TODAY%20it%20will%20be%20highlighted%20in%20green%3CBR%20%2F%3Ecan%20you%20guys%20help%20me%20%3A)%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-728564%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729167%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729167%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368406%22%20target%3D%22_blank%22%3E%40AlinaDenisaCiobotaru%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FHelp-with-Excel%2Fm-p%2F728565%23M33685%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FHelp-with-Excel%2Fm-p%2F728565%23M33685%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi guys,
Can you help me with something ?
i want to compare 2 calendar dates in excel , for example:
DATE 1 - DATE 2
10/3/2017--2/6/2020
1/17/2019--1/17/2020
9/25/2017--1/25/2019
3/21/2018--3/21/2019
as some of the days have been done in the past I would need to compare the dates between themselves and between "today"'s date to have am update of the process any time ;as this dates represent completion days of our colleagues training.
DATE 1 is the date when the training has been completed
DATE 2 is the due date for the next training
If the date is DATE 2 < TODAY by 3 moths range it will be highlighted with red
if the date is DATE 2<= /=> TODAY it will be highlighted with amber/yellow
if the date is DATE 2 > TODAY it will be highlighted in green
can you guys help me :)

1 Reply
Highlighted