Date Function Miscalculations
Posted: 13 Sep 2010 14:51
The =Year(), =DayNumber(), =Timespan() Functions MISCALCULATE Gregorian B.C. years!!
They seem to ignore the A.D. and B.C. selection.
The =Timespan() Function MISCALCULATES Quarter dates.
It seems to ignore the Q1-4 completely!!
The =Timespan() Function MISCALCULATES Simple dates with missing day/month components.
It seems to overlook leap-days if the Timespan is large (more than a few hundred years)!!
Also the Help for =Timespan() says it 'does not allow for the 10 or 11 days that were deducted from the calendar, owing to the changeover date for the Gregorian calendar' but it does adjust for these days the same as =DayNumber()!!
ID:4783
They seem to ignore the A.D. and B.C. selection.
The =Timespan() Function MISCALCULATES Quarter dates.
It seems to ignore the Q1-4 completely!!
The =Timespan() Function MISCALCULATES Simple dates with missing day/month components.
It seems to overlook leap-days if the Timespan is large (more than a few hundred years)!!
Also the Help for =Timespan() says it 'does not allow for the 10 or 11 days that were deducted from the calendar, owing to the changeover date for the Gregorian calendar' but it does adjust for these days the same as =DayNumber()!!
ID:4783