traverse and finding dates

[lavsidhu]

Hi,

I have a table that contains a date and also a count that states the number of immediate week ends from the specific date that I must retrieve.

How to traverse from the date in the table and lets say find the next two week ends, say saturday and sunday with the date being friday

[debasisdas]

Kindly post your table structure with sample data.