having the following table i need to add a new Column called "Round" to represent Round 1, Round 2 and so on, based on the Date Column in the table. Same Round should be given to matches happening in a 3 days timespan (some datediff to be used, can;t figure it out)
Initial Table
Date HomeTeam AwayTeam
2018-08-10 Man United Leicester
2018-08-11 Bournemouth Cardiff
2018-08-11 Fulham Crystal Palace
2018-08-11 Huddersfield Chelsea
2018-08-11 Newcastle Tottenham
2018-08-11 Watford Brighton
2018-08-11 Wolves Everton
2018-08-12 Arsenal Man City
2018-08-12 Liverpool West Ham
2018-08-12 Southampton Burnley
2018-08-18 Cardiff Newcastle
2018-08-18 Chelsea Arsenal
2018-08-18 Everton Southampton
Desired Output
Date HomeTeam AwayTeam RoundNumber
2018-08-10 Man United Leicester 1
2018-08-11 Bournemouth Cardiff 1
2018-08-11 Fulham Crystal Palace 1
2018-08-11 Huddersfield Chelsea 1
2018-08-11 Newcastle Tottenham 1
2018-08-11 Watford Brighton 1
2018-08-11 Wolves Everton 1
2018-08-12 Arsenal Man City 1
2018-08-12 Liverpool West Ham 1
2018-08-12 Southampton Burnley 1
2018-08-18 Cardiff Newcastle 2
2018-08-18 Chelsea Arsenal 2
2018-08-18 Everton Southampton 2