• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto create date for full month

nagovind

Member
Dears,
Say for example in Cell A1, after entering the 1st day of the month as 01-05-2021, I need to get
A2 to A31 full month date of the particular month. i.e auto calculating the date for the date in the cell A1
Instead of dragging/ autofill, need to get the automated date.
Kindly advise
Regards
Govind
01 05 2021​
02 05 2021​
03 05 2021​
04 05 2021​
05 05 2021​
06 05 2021​
07 05 2021​
08 05 2021​
09 05 2021​
10 05 2021​
11 05 2021​
12 05 2021​
13 05 2021​
14 05 2021​
 
or old school
[B2]=IF(OR(A1="",A1=EOMONTH($A$1,0)),"",A1+1)
or alternative with dynamic array
[B2]=SEQUENCE(1,DAY(EOMONTH(A1,0))-1,A1+1,1)
 
Dear Belleke ,
Kindly advise is it possible to make a below row to display ONLY the date without MONTH and YEAR
as 01 02 03 ......31
Regards
Govind
 
Back
Top