https://bugs.documentfoundation.org/show_bug.cgi?id=149940
--- Comment #6 from slavaf2...@gmail.com --- I confirm that the file was originally created with and saved with LibreOffice. No other application was ever involved with that file. Neither Recalculate Hard (Ctrl + Shift + F9) nor Recalculate (F9) produces correct results. Also note that the attached file is a small part of a larger file that I created (but can't attach for privacy reasons). It is a partial copy-paste from the larger file, and I can confirm that I have many VLOOKUP functions looking up many dates going back several years, and as far as I know, the results were always correct. The results became incorrect only when looking up April 22, 2022 date and later. Some dates are missing because only business days (Monday - Friday, excluding holidays) are on the spreadsheet. Normally, the formula returns the value of the closest last date which is available. For example, if we have the following dates: April 29, 2022 May 1, 2022 and the VLOOKUP is asked to look up April 30, 2022, it will give the value for April 29, 2022, which to me is acceptable behavior. Let me know if I've answered all your questions. -- You are receiving this mail because: You are the assignee for the bug.
