Excel Guides

Calculating Week-Ending Dates in Excel

There are a few different ways that you can calculate week-ending dates in Excel. One way is to use the WEEKDAY function. This function takes a date as an input and returns a number between 1 and 7, where 1 is Sunday and 7 is Saturday. So, if you have a date in cell A1, you can use the following formula to calculate the week-ending date:

=A1+6-WEEKDAY(A1)

Another way to calculate week-ending dates is to use the EOMONTH function. This function takes a date and returns the last day of the month that contains that date. So, if you have a date in cell A1, you can use the following formula to calculate the week-ending date:

=EOMONTH(A1,0)+7-WEEKDAY(EOMONTH(A1,0))

You can also use the TEXT function to format dates as text strings in a specific format. For example, if you have a date in cell A1 and you want to format it as "mm/dd/yyyy", you can use the following formula:

=TEXT(A1,"mm/dd/yyyy")

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.