Week ending date and Month end date- Excel WEEKDAY function, DATE function and EOMONTH function

we discuss how to convert a specific date to the corresponding week or month starting date and week or month ending date.
The Excel WEEKDAY function is used to return week ending date with 2nd argument Return type specified depending on the week end day.
Three methods are available to convert a specific date to the month end date: First using the Excel EOMONTH function, second using the Excel Date function formulating next month's day 0

Third, using the Excel date function formulating 1 day before the next month's day 1.
You can download a file.