+ Reply to Thread
Results 1 to 2 of 2

Need to Autofill 'Months' in sheet by entering starting month

  1. #1
    Registered User
    Join Date
    09-06-2007
    Posts
    1

    Need to Autofill 'Months' in sheet by entering starting month

    I can't figure out how I can enter in a month code, say entering 3 for 'March' in a cell, which would then start my sheet out with March and then auto fill the remaining months (April-Feb).

    Please see attachment

    Brian
    Attached Files Attached Files

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Here's one way.....

    Put this formula in B8 and copy across to M8

    =IF($B4="","",TEXT(DATE(0,$B4+COLUMN()-COLUMN($B8),1),"mmmm"))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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