age in days

M

marie

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

Harald Staff

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