Need to convert years into days

[forbes]

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

[R. Choate]

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" <[email protected]> wrote in message news:[email protected]...
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

[Sheila D]

If you have the Date of Birth somewhere on your s/s you could use
=NOW()-CellRef
That will return as a numeric value based on todays date minus the date of
birth

HTH
Sheila

"forbes" wrote:

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

[Daniel CHEN]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[forbes]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

[Bob Phillips]

yeah, in the first just type =a1*365 then copy it down, or select all the
formula cells and type =A1*365 and Ctrl-Enter rather than just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"forbes" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
>

[forbes]

brillant, brillant, brillant. Exactly what I wanted.
Bob Phillips wrote:
> yeah, in the first just type =a1*365 then copy it down, or select all the
> formula cells and type =A1*365 and Ctrl-Enter rather than just Enter.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "forbes" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > > >
> >