Forum Discussion
Excel Dates lookup
I am currently working on a small project where a user inputs hours in a simple form. The hours and the date are stored in a simple list in Columns A (hrs) B (Date). A lookup list of dates are in Col...
paulturner What's happening is that MATCH returns an index number (between 1 and 38), based on the formula provided. And since you format the results as dates. The date value 1 is equal to January 1, 1900 and 38 is equal to February 7, 1900.
- Thanks for your reply so MATCH is not, in this case, a good solution. I didnt want anything complicated!
paulturner Perhaps you need to go with VLOOKUP or XLOOKUP if you are on a recent Excel version.
