I need a formula that will do the following:If cells in columns L, O or Q have a date of today or earlier then cell B must show the text CHECK.
Google Spreadsheet Formula relating to dates
google spreadsheets
Put this in B2, and copy it to where you need it:=IF(OR(L2<=DATEVALUE(NOW()),O2<=DATEVALUE(NOW()),Q2<=DATEVALUE(NOW())),CHECK,-)