Here is a new post which will help you to calculate weekend dates/ day in Excel.
WEEKDAY: This function takes a date and returns a number between 1-7 representing the day of the week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday
serial_number - The date for which you want to get the day of the week.
return_type - [optional] A number 1-3 representing the day of week mapping scheme. The default is 1.
Below In The Example For The WEEKDAY Function And Respective Syntax
Now, we know that the weekday will provide the numerical value which can be used for calculating the week ending dates in the excel.
We know that every business today has its own weekending and month ending dates. hence it becomes easy if we can formulate the week ending date in excel. Also, you can refer my month ending and date difference blogs related to excel
Below is an example to calculate the difference weekend in excel and Respective Syntax
WEEKDAY: This function takes a date and returns a number between 1-7 representing the day of the week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday
=WEEKDAY (serial_number, [return_type])
serial_number - The date for which you want to get the day of the week.
return_type - [optional] A number 1-3 representing the day of week mapping scheme. The default is 1.
Below In The Example For The WEEKDAY Function And Respective Syntax
Now, we know that the weekday will provide the numerical value which can be used for calculating the week ending dates in the excel.
We know that every business today has its own weekending and month ending dates. hence it becomes easy if we can formulate the week ending date in excel. Also, you can refer my month ending and date difference blogs related to excel
Below is an example to calculate the difference weekend in excel and Respective Syntax
Tags:
How to
0 Comments
Please do not spam