How To Extract Or Get The Day Number From A Given Date In Excel Explained - Excel Return Day Number

In this video we discuss how to extract or get the day number from a given date in excel. We go through a detailed example step by step of how to do this
Transcript/notes
Let’s say that you need to extract the day number for a given date, such as in this example. To do this, left click on the answer cell, in this example cell B2, then type in a comma. Next, type in da, and a drop down box will appear. In the box, double click on DAY.
From here, we left click on the date, cell A2. Next, we type in a closed parenthesis to close off the function. Then hit the enter key and we have our answer of 22.
And this will work for a variety of other types of date formats, as you see here.

[@sulfurousstench]

This is very cool thank you! (Is there a formula that will show what day of the week it was for each date?

[@whatsupdude2778]

Yes, here is a link to my video on that... kzbin.info/www/bejne/gHPMiKSjj7d9hac