Closed Thread
Results 1 to 2 of 2

Adding days, weeks and months to my workbook

  1. #1
    Forum Contributor
    Join Date
    01-06-2015
    Location
    london,uk
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2307) 64-bit....Windows 10 Enterprise
    Posts
    118

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Adding days, weeks and months to my workbook

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and 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...-workbook.html
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding weeks below the months row
    By chris1089 in forum Excel General
    Replies: 8
    Last Post: 05-22-2021, 12:26 PM
  2. Adding days, weeks and months to my workbook
    By chris1089 in forum Excel General
    Replies: 1
    Last Post: 05-13-2021, 05:53 AM
  3. Count days, weeks and months between date range
    By ExcelRules2020 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2020, 09:43 PM
  4. RD calculation based on No.of weeks,days,months,years
    By santbiju in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2016, 05:38 PM
  5. RD calculation based on No.of weeks,days,months,years
    By santbiju in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2016, 07:40 AM
  6. [SOLVED] Returning 'Number' of 'Days' or 'Weeks' or 'Months' with # and text
    By PERE in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2013, 08:45 PM
  7. [SOLVED] How do I sort by date (not days, weeks, months) in Excel 2000?
    By Tony in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1