I'm new here and a Crystal novice but  hoped someone could help me with a report I am currently designing.

The report is designed to show various hours, shifts and activities for people and is nearly done but there is one field that I am having trouble with.

There is a flag in the database which shows when a weekend day has been worked. 
So I can easily retrieve a list of start and end times for each shift that took place on a weekend. 

From this I can calculate number of weekends and weekends off.


However I need to flag how many sequential weekends were worked and need a formula to calculate this.


Any suggestions gratefully received

I believe the entire weekend but presumably once I have the formula I can tweak the interval it checks.

Sorry but need a bit more detail.  What formula can I use to see if the flag exists in the previous 7 days.

Dates in the db are stored in unix time if that makes a difference but I also have them converted to date format too.