Kal-El
05-30-2017, 08:41 AM
I have a Date in Cell A1 and I need to compare it against dates in Cell C1,D1,E1
If cel A1 is not the first day of the month then "Not Aligned"
If Cel A1 is the first of the month but the date in either C1,D1,E1 does not match then "Not Aligned"
IF If Cel A1 is the first of the month and the date in either C1,D1,E1IS the matching first day of the Month of A1 then "Aligned"
Any thoughts
If cel A1 is not the first day of the month then "Not Aligned"
If Cel A1 is the first of the month but the date in either C1,D1,E1 does not match then "Not Aligned"
IF If Cel A1 is the first of the month and the date in either C1,D1,E1IS the matching first day of the Month of A1 then "Aligned"
Any thoughts