https://bugs.documentfoundation.org/show_bug.cgi?id=141758
--- Comment #7 from Nigel Lee <[email protected]> --- The isdate() function recognises a date entered in dd/mm/yyyy format, but not another cell which adds 1 (day) to that date, which is returned as a number. (I creted a calendar in Excel, which uses a combination of formulae and formatting to determine subsequent date values by adding 1 (day) or 7 (week) for sequencial rows and columns. I added code to scan the sheet and compare dates against a list of events (e.g. birthdays) from another sheet, to automatically fill in details in the corresponding position (each 'day' is made up of 3 rows). It works fine in Excel, but fails in Libre Office VBA, because I use isdate() to skip values before the start, and beyond the end, of the month, and it doesn't recognise a numeric date value! -- You are receiving this mail because: You are the assignee for the bug.
