Extract day number from a valid excel data with Day function.
In simple words, it will return day from a date ignoring month and year. It will give you the number of the day ranging from 1 to 31 from a date you have mentioned.
In the below example, I have used day function to get day number from a date. You can use this function when you have dates in your data and you only need day number.
And, in the below example, I have used this function to create a dynamic formula which returns current day number and it will update every time you open your worksheet or when you recalculate your worksheet.
To learn more about Excel DAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.