The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).

So if you want to find out on what day you were born, then the WEEKDAY function will remind you.

DOWNLOAD WORKBOOK

Weekday

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Calculate Total Sales With An Array Formula An Array Formula performs an Excel operation (math, comparative, join or function argument) on an array or range of data.  This could be a range of cells, a worksheet reference or a defined name.One of the most popular uses of an array formula is to calculate Total Sales....
RANDBETWEEN Function I use the RANDBETWEEN function all the time whenever I need to create a sample data set.The cool thing about the RANDBETWEEN function is that if you don't like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downl...
Two Way Lookup Using The SUM Intersect Function There are various lookup functions that bring back values from a range of data like the VLOOKUP, INDEX, INDEX-MATCH and OFFSET functions, just to name a few.There is another lookup formula that you can use that will return the intersection of two Named Ranges!This is done...
INDIRECT Function for Dependent Dropdown Lists in ... The INDIRECT function is really cool as it opens up a lot of interesting combinations in Excel.We will use the power of the INDIRECT function right now on creating Dependent Dropdown Lists.DOWNLOAD EXCEL WORKBOOKLet us go through the steps in detail: STEP...