Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know what formula I would use to figure out in Excel how many days
before birthday. I also have the date they were born.
 
If you just subtract dates and format the result as general, you'll see the
number of days between the dates.

So if your birthdate was in A1 (say June 10, 1973), you could use:

=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY()
or
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY()-1

Depending on if you count the birthday or not.
 
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

Workday Formula to include date 0
How do I Modify Julian calendar restriction of 1900 2
Calculating Date of next birthday 3
IF function with dates 2
Asset Management - PC Birth Date 11
Birthday Calculations 1
Please help with formula (multiple ifs to determine due date) 3
Happy Birthday @Ian 7

Back
Top