I have two sets of dates that I need to compare using <,>,=. One of my dates is formatted mm/dd/yyyy. the other date is mm/yyyy.
The goal is for both sets of numbers to include ONLY mm/yyyy. not only in the way they are displayed to the user but in terms of actual value.
my goal is to show that something occurred in the month it was intended to happen
(mm/dd/yyyy = mm/yyyy for example 01/15/2016=01/2016 as january 15th occured in the month of january)
however using the traditional text option (= TEXT(A2,"mm/yyyy) doesn't work as they are TEXT fields and i cant get the operations >,<,= to work and if i just change the formatting the original date is retained and so in the above example it would show that 01/15/2016= 01/2016 is FALSE.
ive been working on this for too long!