Adding days, weeks and months to my workbook

However, I'm not sure how to do the following. Could you please assist:

- Adjust row 6 so that years are captured in accordance to row 10 (a manual attempt has been made - see column W and AI)
- Adjust row 8 so that months are captured in accordance to row 10 (a manual attempt has been made - see column K and R)
- Extend the Green colour captured in row AA 9-12 (highlights today's date)


Cheers
Chris