Using the formula I posted the calculation will be correct. There is a
DAYS360 function in Excel which uses a 360 day year for accounting
purposes but, other than that Excel will calculate using 365 day or 366
day years as appropriate


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524789