lucystewart
New Member
- Joined
- Aug 31, 2019
- Messages
- 4
Hello,
I am working on a staffing sheet. I have a list of dates in weekly increments going across row 2 (starting at M2 and going on to ZZ2).
And I need a way to retrieve the number in row 54 that corresponds with todays date. The tricky part (to me) is that todays date isn't going to necessarily match the date in row 2. So I need it to pull from the column with a date that has passed.
Meaning:
54 20 24 22 18
Today's date is 8/31 so I would need it to return the #24 from cell N54.
I don't know if this can be done with a Vlookup? I don't currently have a =today() in any cell but I could, of course, put it somewhere if that is helpful.
Thank you so much for any help you can provide.
Lucy
I am working on a staffing sheet. I have a list of dates in weekly increments going across row 2 (starting at M2 and going on to ZZ2).
And I need a way to retrieve the number in row 54 that corresponds with todays date. The tricky part (to me) is that todays date isn't going to necessarily match the date in row 2. So I need it to pull from the column with a date that has passed.
Meaning:
M N O P
2 . 8/18/2019 . 8/25/2019 . 9/1/2019 . 9/8/201954 20 24 22 18
Today's date is 8/31 so I would need it to return the #24 from cell N54.
I don't know if this can be done with a Vlookup? I don't currently have a =today() in any cell but I could, of course, put it somewhere if that is helpful.
Thank you so much for any help you can provide.
Lucy