J James Nix New Member Dec 8, 2014 #1 I want to compare two dates in different fields to determine if the date reported was in the same month as the event date. Event date Reported date 1/12/2014 1/15/2014 1/15/2014 3/10/2014
I want to compare two dates in different fields to determine if the date reported was in the same month as the event date. Event date Reported date 1/12/2014 1/15/2014 1/15/2014 3/10/2014
N NARAYANK991 Excel Ninja Dec 8, 2014 #2 Hi James , There are 2 ways : 1. Compare the month and the year of both dates : =AND(MONTH(Eventdate) = MONTH(Reporteddate) , YEAR(Eventdate) = YEAR(Reporteddate)) 2. Use the TEXT function : =TEXT(Eventdate , "yyyymm") = TEXT(Reporteddate , "yyyymm") Narayan
Hi James , There are 2 ways : 1. Compare the month and the year of both dates : =AND(MONTH(Eventdate) = MONTH(Reporteddate) , YEAR(Eventdate) = YEAR(Reporteddate)) 2. Use the TEXT function : =TEXT(Eventdate , "yyyymm") = TEXT(Reporteddate , "yyyymm") Narayan
