Calculate number of days
As others have said, it depends on the start date.
If the start date is in A5, the number of days is
=DATE(YEAR(A5)+A1,MONTH(A5)+A2,DAY(A5)+A3)-A5 and format as General or
Number.
--
David Biddulph
"Linda P." Linda wrote in message
...
I am using Excel 2000.
I need help with a formula. In A1 I have # of years, in A2 I have # of
months and in A3 I have # of days. In A4 I want to add A1 through A3 and
show the total as number of days. Thanks for your help.
|