Automatically fill dates based on Month and Year

**grcshekar** · 02-03-2021, 03:20 AM

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

**Bo_Ry** · 02-03-2021, 03:40 AM

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

**grcshekar** · 02-03-2021, 03:43 AM

WOW ! Thank You

**samba_ravi** · 02-03-2021, 03:43 AM

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

Automatically fill dates based on Month and Year

LinkBack

Thread Tools

Rate This Thread

Display

Automatically fill dates based on Month and Year

Re: Automatically fill dates based on Month and Year

Re: Automatically fill dates based on Month and Year

Re: Automatically fill dates based on Month and Year

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pivot Table Automatically Grouping Dates by Year, Quarter, Month etc

Hide columns automatically based on year and month imputs

Hide Columns automatically based on year month(YYYY-mm)

[SOLVED] formatting dates to automatically extract Year and month

Automatically get all the dates of a month, entering specific year and month

Based on col dates create col of dates for the first day of that same month and year

Automatically fill in dates two weeks and one month ahead of date inputted manually

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions