+ Reply to Thread
Results 1 to 4 of 4

Automatically fill dates based on Month and Year

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Automatically fill dates based on Month and Year

    Dear Experts,

    In the attached Sheet, I have entered month and year in B1.
    From C3 to AD3 I have typed dates manually. Is there a way to automatically populate dates based on B1
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,021

    Re: Automatically fill dates based on Month and Year

    Please try at column C

    =IF(COLUMNS($C3:C3)>DAY(EOMONTH($B$1,0)),"",COLUMNS($C3:C3))

    or
    =IF(COLUMNS($C3:C3)>DAY(EOMONTH($B$1,0)),"",$B$1-1+COLUMNS($C3:C3))
    custom format d
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Re: Automatically fill dates based on Month and Year

    WOW ! Thank You

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,128

    Re: Automatically fill dates based on Month and Year

    c3=IF(COLUMNS($B3:B3)>DAY(EOMONTH($B1,0)),"",SUM(B3,1))
    try the above formula, copy and paste towards right
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-19-2020, 07:42 AM
  2. Hide columns automatically based on year and month imputs
    By ToroRubio in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-02-2020, 10:53 AM
  3. Hide Columns automatically based on year month(YYYY-mm)
    By Jeevhoney in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2014, 12:53 AM
  4. [SOLVED] formatting dates to automatically extract Year and month
    By alexcrofut in forum Excel General
    Replies: 1
    Last Post: 01-23-2014, 03:09 PM
  5. Replies: 2
    Last Post: 12-01-2012, 03:06 PM
  6. Based on col dates create col of dates for the first day of that same month and year
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2011, 09:32 PM
  7. Replies: 5
    Last Post: 06-21-2011, 09:10 AM

Tags for this Thread

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