how to collect a date within a sheet?

Brandon Morales

Hi, in the image below I have in my "extrusion" column an entry that populates by a formula (in this case "M3406 HEAD TRACK 15' is populating) I'm looking to populate the "Last Cycle Count Date" column by searching the "last cycle count date" from rows 1:49 looking for a date that has the "extrusion column from rows 1:49 with a match of row 52 in my "extrusion column".

My current formula is not working and simply says: Date Expected

Paul Newcome

Try wrapping it in an INDEX function like so:

=INDEX(COLLECT(………………….), 1)

Paul Newcome

Try wrapping it in an INDEX function like so:

=INDEX(COLLECT(………………….), 1)

Brandon Morales

thanks paul. that did the trick!

Paul Newcome

Happy to help. 👍️