For the original poster, the ROW_NUMBER() function you're looking for would look like this:

ROW_NUMBER() OVER(PARTITION BY [Name] ORDER BY [Date]) AS Weekdays

The PARTITION BY portion will start the numbering over with each different Name value, and is considerd a "Window" function, because it doesn't require a GROUP BY, but can still see values from other records than the current one.