| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to convert years into days
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to convert years into days
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to convert years into days
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to convert years into days
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" wrote in message oups.com... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to convert years into days
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" wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
| I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) | |||
| need help with formula | Excel Discussion (Misc queries) | |||
| Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
| Number of years, months, days between two dates. | Excel Worksheet Functions | |||
Linear Mode
