I have a very large spreadsheet with many dates in each row with the DD-MMM-YYYY format. I would like to return a 'YES' for all rows with dates less than a certain date (which will change) and return nothing if the value is greater than that date.
For ex. if I want to return all dates in a row less than 01-Mar-2018. I tried this formula:
=IF((J377:X377)
Any ideas as to what I am doing wrong? Thanks, Scott!
IF
. This should get you started on usingIF
correctly=isnumber(A1)
or `istext(A1). Conversely, you can try changing the cell format to general. If it still looks like a date while formatted as general its text. If it changes to some large integer its a number. Note changing the format to date does not change how it is stored. Cell formatting only changes how information is stored.