Thread: Calculate number of days
View Single Post
  #3  
Old April 23rd, 2010, 07:20 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
  
Posts: 3,722
Default Calculate number of days
=EDATE(1,A2+A1*12)+A3


"Linda P." wrote:

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.