I have a column full of dates, ranging from 1/4/2004 onwards in A2:A400
Another cell (B1) contains a validation list of each of the values in A2:A400.
What I would like to do, if possible (?) in B2 is reference the value in B1 and take the first previous date.
For example: If B1 said 31/12/2004, then B2 would show 30/12/2004, and if B1 said 1/1/2005 then B2 would return 31/12/2004.
Is this at all possible ? The reason I am asking is so that using a vlookup I can select a date with associated data and in the next line show the previous days data.
Many thanks for your help.
Scott
Bookmarks