Search Not Just Numbers

Tuesday, 5 October 2010

An Introduction to working with dates in Excel

I find that many clients are quite comfortable working with financial figures in Excel, but don't know how useful Excel can be when manipulating dates.

I thought that it might be useful to provide a short post on some of the most useful functions for handling dates in Excel.

One of the simplest functions is the TODAY function, which can be used on its own or within another formula to return today's date. It has no arguments and is essentially a variable (Excel still requires empty brackets after it so that it has the same format as other functions)..


=TODAY()          will display today's date in the cell

I covered YEAR, MONTH and DAY in an earlier post. These allow you to return the year, month or day respectively (as a number).


Where cell A1 contains the date 5th October 2010,

=YEAR(A1)   returns 2010
=MONTH(A1)   returns 10
=DAY(A1)    returns 5

WEEKDAY allows you to identify the day of the week (as a number) of any date. It has two arguments, the first being the date you wish to use and the second (optional) argument being the number 1,2 or 3 depending on how you want to number your days.

1:  Sunday=1 through to Saturday=7
2:  Monday=1 through to Sunday=7
3:  Monday=0 through to Sunday=6

If this argument is not entered then it defaults to setting 1.


Where cell A1 contains 5th October 2010 again (a Tuesday),

=WEEKDAY(A1)   returns 3
=WEEKDAY(A1,1)   returns 3
=WEEKDAY(A1,2)   returns 2
=WEEKDAY(A1,3)   returns 1

I hope this has made you feel a little more comfortable when working with dates in Excel.

Don't forget if you want to take the even easier route, we can build your spreadsheet for you at Spreadsheets by Email.

If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.

1 comment:

  1. Although there's just a little bit of prejudice, the end result is completely various that could cause you to poor feeling, particularly about the day time associated with wedding ceremony, exactly what might perform for that wedding brides. Have you been asking yourself to purchase the very best infant presents for the kid in order to find absolutely no idea? This time around a person sooo want to possess Infant Dior as well as replica omega couture ladies obtainable. This season the actual party or even every other event will be converted into the greatest magic in your life. There are many shops that provide such most respected top quality infant presents for example Infant Dior, tote couture ladies, absolutely no additional sugars yet others. For those who have adequate time for you to get ready for relationship, which means you might select your preferred hermes outlet as well as dress yourself in these types of couple of months time for you to exercise this consciously. You'd resolve the issue prior to wedding ceremony. Very first, put on couple of sets associated with man made fiber socks. Elevated the actual width associated with man made fiber tights might normally boost the safety from the pores and skin, reduce feet stress, as the beautiful consistency associated with man made fiber tights additionally perform an excellent lubrication impact which could slow up the rubbing in between feet as well as le boy chanel bags. The following is by using document hand towel because insole. Should you sense your own fake handbags unpleasant whenever which wedding ceremony unique period occurred, you should purchase the heavy insole as soon as possible or even place a few document hand towel in to your own replica dior release a the actual stress of the ft.