I'm afraid you would need VBA to do this.
You can have a look at the function Datediff(), maybe you can figure
out a way with cell formulas to get it done but I don't.
--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile:
http://www.excelforum.com/member.php...o&userid=26182
View this thread:
http://www.excelforum.com/showthread...hreadid=399494