Forum Discussion
Vlookup by date/time in pivot table
hi i'm trying to lookup a value in a pivot table by date/time in previous month and am only getting the top value from the column. how do i add time to the eomonth function or date/time to vlookup, help please!
=VLOOKUP(EOMONTH(TODAY(),-1) +13,1:1048576,5,FALSE)
11 Replies
Perhaps
=VLOOKUP(EOMONTH(TODAY(),-1)+13.99999,A:E,5)
By the way, EOMONTH(TODAY(),-1)+13 is the 13th of the current month (i.e. December 13, 2021 as I write)
yes i thought that might work so i went to 13.5 but it comes back with NA. i know i'm in this month because i just started generating my data this month but in January I'm hoping to use this function to generate a report. thankyou HansVogelaar
Could you attach a small sample workbook without sensitive/proprietary information?
