Hi, I am trying to use VLookup to find the last date that a value was entered
in. I then use this date in a different location to calculate MTD Goals. My
spreadsheet looks like the following:

Date Total
9/1 $5312.44
9/2 $3419.67
9/3 $1619.17
9/4
9/5
9/6
9/7
to 9/30

This a standard format that is submitted to me with the data. So I would
like to be able to return the date of 9/3 since it is the last day with a
value. Any help would be greatly appreciated as I would then be able to
automate my report without have to enter in the last date of data available.
Thanks for any help.