I need a week number formula that is similar to WeekOfYear() except it doesn't reset on Jan 1.

The number it generates is arbitrary. It just needs to calculate the next number in it's sequence every 7 days.

Kyle

I need a week number formula that is similar to WeekOfYear() except it doesn't reset on Jan 1.

The number it generates is arbitrary. It just needs to calculate the next number in it's sequence every 7 days.

Kyle

I'm making a time clock type of program. I will have a number of records containing timestamp fields and need to group/summarize them by a week (Mon-Sun). The week calculation would be based on one of these timestamps. The normal WeekOfYear function works perfectly, except it will fail when a week spans a new year.

Kyle

KylePutzier wrote:

need to group/summarize them by a week (Mon-Sun).

IMHO, it would be best to use a calculation that returns the date of the first day of the week (this is useful for labeling the group).

For a week starting on Monday, try =

Let ( [

d = GetAsDate ( TimestampField )

] ;

d - Mod ( d - 1 ; 7 )

)

Kyle, did you know that you can auto-enter a serial number and specify the increment to be something other than "1"?

Start with any number you want, and increment by "7".

HTH,

Beverly