Microsoft Office Tutorials and References

In Depth Information

**Determining the Day of the Week**

Counting the days until your birthday

After a certain age a lot of people wish their birthday would not come around

so often, but if you still like birthdays you can use Excel to keep track of how

many days are left. Entered in a cell, this formula tells you how many days

are left until your birthday (assuming that your next birthday is May 5, 2014):

=DATE(2014,5,5) - TODAY()

Use the DATE function to enter the day, month, and year of your next

birthday. This avoids having a shorthand entry, such as 5/5/2014, be interpreted

as a mathematical operation on its own.

If the formula were =5/5/2014 – TODAY(), an incorrect answer would be

calculated because this effectively says, “Divide 5 by 5, then divide that result

by 2011, then subtract the serial number of today’s date.” The answer would

be incorrect.

Using the DATE function to represent dates in which a mathematical

operation is performed is a good idea.

Counting your age, in days

When your birthday finally rolls around, someone may ask how old you are.

Maybe you’d rather not say. Here’s a way to respond, but in a way that leaves

some doubt: Answer by saying how old you are in days!

Excel can help figure this out. All you have to do is count the number of days

between your birth date and the current date. A simple formula tells you this:

=TODAY() - DATE(birth year, birth month, birth day)

Here’s an example, assuming your birthday is March 18, 1976: =TODAY() -

DATE(1976, 3, 18).

Determining the Day of the Week

The Beatles wrote a song called “Eight Days a Week,” but for the rest of us

seven days is the norm. The WEEKDAY function helps you figure out which

day of the week a date falls on. Now you can figure out whether your next

birthday falls on a Friday. Or, you can make sure a planned business meeting

does not fall on a weekend.