Forum Discussion
Kiley880
May 03, 2021Copper Contributor
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!
1 Reply
- Riny_van_EekelenPlatinum Contributor