age in days

  • Thread starter Thread starter marie
  • Start date Start date
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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Birthday stuff 21
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
max values in two ranges 4
Please help with formula (multiple ifs to determine due date) 3
how to evaluate approx "birthday" knowing "age" and current date 7
Suming Up Time over the course of days 1
Age calculator 1
Current Age by years and months 7

Back
Top