In case there is not an exact matching date try:

=MIN(IF(F1:F31=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),F1:F31))

Array entered with Control + Shift + Enter instead of just Enter otherwise
you will get a date of January 1 1900

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
oups.com...
I am trying to find the row number, to use in a formula, of a row with
a date 365 days or 1 year ago.

I need this to perform some cacluations on the last 12 months worth of
data. Is there a simple excel function to do this or will I need a
makro?

Thanks