Create Counting Calendar

[Surreal Method]

My programming skills are limited, but given time I usually figure things out. I just don't know where to start so hopefully someone can guide me to the correct path.

I have this file that was created 7+ years ago to record how long a contract has been in effect. If you open the file you can clearly see it isn't efficient and it is very cumbersome.

My idea is as follows:
1) User inputs contract start date then user inputs how many days are in the contract.
2) Macros use this information to create a calendar that starts on the contract start date, then numbers every day till the last date.

If you use the excel spreadsheet I have included, you can see the numbering system that was developed. I would like to continue using that, so the macro should create a generic 31 column "month" so that as the days progress a new month is inserted underneath that one till the last contract date is achieved.

With that done I believe I could continue tayloring the spreadsheet to my needs. Thanks in advance for everyone's help.

- Frank

[Surreal Method]

Let me ask these questions then and maybe someone can offer advice and let me get started on the macros.

How can I make a Macro to copy a range of cells into the immediate rows underneath given if certain conditions are met? This will allow me to create 1 field 31 columns wide and if the contract last 2+ months then it would get copied over till the last month.

Is there an easy way to copy this formula over to the next cell?
=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
The next cell would be =CHOOSE(WEEKDAY(A1+1),"......, then =CHOOSE(WEEKDAY(A1+2),"..... If I do the drag the box method, it icreases the cell reference too as in B1 then C1.

I can use that information to start what I want to do with my file and then if I get stumped I can come back here and ask for help. I'm not asking for someone to do everything for me, but just guide me on how I may achieve it.