I have data as shown below. All the data has the same date in the BILLDATE column (e.g., 01/04/2015; that's dd/mm/yyyy). I want to adjust the dates on these 70 records in a particular month so that after every 4 records, the date will be incremented to the next day automatically, as shown in the Output column.
For example, for the first 4 rows, the date will be 01/04/2015, and for the next 4 rows the date will be 02/04/2015, and for the next the date will be 03/04/2015, and so on, until 30/04/2015, when all 70 records should be adjusted. I want output like shown in this image.