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

If you don't care about leap years, then are you using the simple formula of (1*365)? obviously you would substitute a cell
reference in place of the 1 so it would accomodate any number. If you want to be more accurate, you will need the birth date and
current date =TODAY(), or whatever date you want to use as your cutoff date for purposes of calculation.

HTH
--
RMC,CPA


"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