mikerickson
MrExcel MVP
- Joined
- Jan 15, 2007
- Messages
- 24,355
This is about the VBA function DateDiff, not the worksheet function DATEDIF.
I've recently found that DateDiff("d", "1/7/1900", "1/8/1900") returns 0 instead of the expected 1.
And there are 3 other dates that have a 0 DateDiff from the next day, 5/6/1900, 6/4/1922, 9/16/1989
This bug also effects the results of date ranges than include those dates.
Is this a known bug?
Thank you for reading.
I've recently found that DateDiff("d", "1/7/1900", "1/8/1900") returns 0 instead of the expected 1.
And there are 3 other dates that have a 0 DateDiff from the next day, 5/6/1900, 6/4/1922, 9/16/1989
This bug also effects the results of date ranges than include those dates.
Is this a known bug?
Thank you for reading.