PDA

View Full Version : Formula to put row number based on a date



bopha99
01-28-2015, 03:55 PM
I have a list of dates and would like a formula to put the row number of a certain date. For instance, in the list of dates, I have 12/31/2014. I would like the formula to reference the date and give the row number where that date shows up. Thanks in advance.

Bob Phillips
01-28-2015, 04:13 PM
Use

=IFERROR(MATCH(--"2014-12-31",A:A,0),"")

bopha99
01-29-2015, 11:31 AM
Great. Thanks.