Using cf grid, need some input on creating editable columns.

I an trying to create a revenue page,

1st issue:

Columns will have the days in the month - not sure how to do this without hard coding it in but would like to somehow dynamically populate this.

The data will be pull from a database:

https://bubbl.us/view/2788d1/5195a9/25F4oONgeDEtU&r=1719403621/

2nd issue:

How can i match the date entry in the database with the approriate column.

There might be another way to do this which I'm open to, can't seem to wrap my head around this issue.

Any input is appreciated.