I need a way to detect if a field is a date in a sumif expression.
Column X contains numbers, column Y MAY contain a date. If column Y has a date in it (otherwise blank), add the column X amount. =SUMIF(Y3:Y75, ?criteria? ,X3:X75)
ADV Thanks!!! ANCE
Al
There is no special data type Date, hence you can’t detect a date. Dates are integer numbers counting (better: indicating) the days since 1899-12-30 - see OASIS ODF Documentation - 4.3.3 Date. What you see in a date-formatted cell is a representation of that integer.
… as Opaque says, a date is a number, so the criteria I was looking for can be simply “>0” (with the double quotes), and (blush) don’t forget to format the cell containing the answer properly…