You have an invite with the date of the event stated as 20/03/2023
I believe the first thing you would love to know is what day of the week is 20/03/2023
The WEEKDAY Excel function can be of great help.
The function returns a number from 1 (Sunday) to 7 (Saturday) which represents a day in the week.
The syntax of the WEEKDAY function is =WEEKDAY(serial_number,[return_type])
If you omit the second argument which is optional though, Excel returns 1 for Sunday and 7 for Saturday – the result is the same when the return type is 1.
Use the link below to understand how this function works.
Download the workbook used in this tutorial HERE
Ensure you practice along for better understanding.
Hey!
I will love to know if you got value from this video tutorial.
Kindly use the comment section to send your feedback as this will help serve you better.
Do well to share this value tip with others.
Amaka Cares!
#dexcelcoach