End of Week Function

[Smith955]

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

 

[JayMenon]

Hi !

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

This should do it. Pls post your comments.

Thanks

 

[Yogi Anand]

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
	A	B	C	D
1	date	EndofWeek(Saturday)	EndofWeek(Sunday)
2	8/23/02	8/24/020:00	8/25/020:00
Sheet3

</SPAN>

Regards!

Yogi

 

[IML]

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)

 

[JohnGalt82]

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

 

[rdavidson1911]

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