Forum Discussion

Kiley880's avatar
Kiley880
Copper Contributor
May 03, 2021

Finding a date minus 1 year then giving the value in next column.

I have several columns but the first column has dates, the second is the number of units sold up to that date.  These dates are from last year.  I would like to find the number of units sold up to the date one year ago.

The closest that I have got is:

=VLOOKUP(MAX(A4:A300),A3:B300,2,FALSE)

this gives me the total number units sold last year, not to date minus a year.

I'm close but not close enough.

I appreciate any help at all.

 

Thank you in advance!

Resources