View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Calculate number of days

That can't be done... the number of days in the month depends on the start
date for the calculation. For example, two months starting January 1st has a
different number of days in it than two months starting on March 1st.

--
Rick (MVP - Excel)



"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.