Adding days, weeks and months to my workbook

**chris1089** · 05-13-2021, 04:17 AM

I've been trying to add weeks, days and months to my workbook. However, I'm unfamiliar with the formula. Could you please assist?

These are the elements I'm struggling with:

- 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

**Richard Buttrey** · 05-13-2021, 05:53 AM

Administrative Note:

Welcome to the forum.

Having just closed another of your threads today, I note both of these are essentially associated with the workbook you posted earlier in April that Pete last helped with. Hence I'm treating this as another duplicate. You are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ml#post5515797

Adding days, weeks and months to my workbook

LinkBack

Thread Tools

Display

Hybrid View

Adding days, weeks and months to my workbook

Re: Adding days, weeks and months to my workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adding weeks below the months row

Count days, weeks and months between date range

RD calculation based on No.of weeks,days,months,years

RD calculation based on No.of weeks,days,months,years

[SOLVED] Add additional days/weeks/months based on user input

[SOLVED] Returning 'Number' of 'Days' or 'Weeks' or 'Months' with # and text

How do I sort by date (not days, weeks, months) in Excel 2000?

Bookmarks

Bookmarks

Posting Permissions