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.
Search JabSto ::

Custom Search