View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
forbes
 
Posts: n/a
Default Need to convert years into days

Yup, that is what I want; but what I need is an easy way to reference
7842 rows of data. I was wondering if there was a formula that took the
values of row C and multiplied them by 365 without me manually changing
the formula for each row of data.

Thanks
Kim

Daniel CHEN wrote:
In Cell I1, type =C1*365.
Is this what you want?
You input in C1 is 1, right?


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"forbes" wrote in message
ups.com...
This seems like it should be pretty basic, but i can't seem to figure
it out.
I need to convert data in row c: (Age in years) to Age in days (in row
I)
For example, if the patient is 1 years old, I need to convert 1 in row
C to 365 in row I.
Thanks!
Kim