Append Date as Header field in Excel File

[mkiefer1]

Any suggestions on the best way to append data to a sample file such that we can create the date in Yellow in the same date format as the previous cells.  

[christine_assaad · Accepted solution]

Hi @mkiefer1 

Please check this out. I tried to generate dynamically the months - up to current one. Hope this is what you are looking for.

[mkiefer1]

This is great thanks @ christine_assaad.

Can i ask also - what would be the best way to lay in data underneath that new field that was created (July 20th).  So every month there will be new numbers that drop in - so for example, the attached 'new data' would need to align with the new column that was created so that jul 20 would read:

Carrier	Jul-20
Joe Smith	800
John's trucking	500
Seabird Transport	200
Grand Total	1,500

[christine_assaad · Accepted solution]

Hi @mkiefer1 

Please see attached. It is pretty lengthy but working. Perhaps there are more elegant ways to achieve the same goal 🙂

[mkiefer1]

Awesome thanks @Christine_assaad.  I can tweak this slightly to get what I'm looking for - thanks again!