# End of Week Function

#### Smith955

##### New Member
Is there a way to calculate the "end of week" similar to the "end of month" function?

I am wanting to group a list of dates by week.

Thanks

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Hi !

I suggest you create a pivotal table; under Group and Show Detail choose Group; Days and
set the days to 7.

Thanks

On 2002-08-23 11:28, Smith955 wrote:
Is there a way to calculate the "end of week" similar to the "end of month" function?

I am wanting to group a list of dates by week.

Thanks

To compute the EndOfWeek for a given date you casn use the WeekDay function to get the EndOfWeek date foe weekending on Saturday or Sunday

see the worksheet simulation:
Book1
ABCD
1dateEndofWeek(Saturday)EndofWeek(Sunday)
28/23/028/24/020:008/25/020:00
Sheet3
</SPAN>

Regards!

Yogi

On 2002-08-23 11:28, Smith955 wrote:
Is there a way to calculate the "end of week" similar to the "end of month" function?

I am wanting to group a list of dates by week.

Thanks

Also consider the weeknum() function for your grouping (you must first install the anaylyst tool pak to use this function)

To calculate the End of Week function use the following.

= Date + (6 - Weekeday(Date))

This is if you want Friday as the week end. Depending on the date you want as the week end use the key below to replace the number 6.

Sunday = 1
Monday = 2
Tuesday = 3
Wednesday = 4
Thursday = 5
Friday = 6
Saturday = 7

Thank you, JohnGalt82. This was very helpful. By the way, who is John Galt. j/k. I love Ayn Rand.

Replies
3
Views
284
Replies
2
Views
231
Replies
4
Views
117
Replies
7
Views
239
Replies
3
Views
175

1,202,908
Messages
6,052,488
Members
444,587
Latest member
ezza59

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back