Just to know how to compare/match a single dates compare with a column/range of dates
For example, column A is the holidays of a year, if I input a date in cell B1, if B1 is match with any date in column A, then will display "holiday' on cell c1, if B1 doesn't match with column A, then will display "working_day" on cell C1.
I have try this buy it seem don't work =IF(B1=A1:A20,"HOLIDAY","WORKING_DAY")
Bookmarks