calculating due dates and february differences
Excel knows the number of days in February for every year except 1900. So
unless you're dealing with that year, it's not an Excel problem.
Are you perhaps using Days360 to add dates? That would cause February to
have 30 days.
Regards,
Fred.
" wrote
in message ...
I have a spreadsheet that takes a start date and calculates the date that a
recertification is due. There are 4 certification periods 90days, 90days,
60days and 60days. My current formula looks something like this B2=A1+89,
C2=B2+90, D2=C2+60.
This has been working fine except that Excel is considering February has
30
days vice 29, is there a way to fix this?
Or to make the process simplier?
Any help would be gratefully accepted.
|