What is the range of dates that you require to display?
If the range is not too great you maybe able to adapt the following.

I have a rolling roster program which uses a list  for the source for a
combo box  to select  the month.
We only need to show 7 months past, the current month & 13 months in the
future.
This is accomplished by row 8 of the list being set  to:
=DATE(YEAR(NOW()),MONTH(NOW()),1)
The earlier months are set to the above formula with a month setting:
Month(Now()-1) etc.
The later months are set to the above formula with a month setting:
Month(Now()+1) etc.

Have never had the need to go down to actual days, but think that could
be done if the range is not too great, or not desirable but could be
accomplished using multiple combo's for Day, Month, Year and then some
form of concatenation.