childsremix
New Member
- Joined
- Oct 30, 2003
- Messages
- 8
Hi can anyone tell me if possible if excel can convert a number such as 332 into years, months, and days? If so how? By the way I just bought this book (my mom did for me, im only 15 1/2) called excel 2003 formulas by john walkenbach. Im still new to excel so give me sometime...
One last question, is it possible, perhaps via macros or something to enter data and have the formula already written into the appropriate box and know the appropriate cell to retrieve the data. For example in cell A1 I have the persons birthday, in cell b1 I have a specific date in cell c1 I have the difference. When I enter the next persons birthday in a2 and a specific date in b2 can it automatically generate the differnce for me in c2 somehow? Thanks.
One last question, is it possible, perhaps via macros or something to enter data and have the formula already written into the appropriate box and know the appropriate cell to retrieve the data. For example in cell A1 I have the persons birthday, in cell b1 I have a specific date in cell c1 I have the difference. When I enter the next persons birthday in a2 and a specific date in b2 can it automatically generate the differnce for me in c2 somehow? Thanks.