M marie Mar 3, 2004 #1 hi, i was wondering if anyone knows how to work out my age in days my birthday is the 05/08/88 and todays date is 03/03/04 thanks!
hi, i was wondering if anyone knows how to work out my age in days my birthday is the 05/08/88 and todays date is 03/03/04 thanks!
F Frank Kabel Mar 3, 2004 #2 Hi have a look at http://www.contextures.com/xlfaqApp.html#Unused and use the DATEDIF function with the "d" parameter
Hi have a look at http://www.contextures.com/xlfaqApp.html#Unused and use the DATEDIF function with the "d" parameter
H Harald Staff Mar 3, 2004 #3 Hi 1 is a day in Excel. So: Birthday in A1, Today (or whenever) in B1. Formula in C1: =B1-A1 format C1 as general or number -it will default as a date and display nonsense.
Hi 1 is a day in Excel. So: Birthday in A1, Today (or whenever) in B1. Formula in C1: =B1-A1 format C1 as general or number -it will default as a date and display nonsense.
