How to automate calendar in excel by the given criteria

dinesh.sarsar

New member
Joined
Sep 8, 2014
Messages
21
Reaction score
0
Points
0
Location
India, Maharashtra Pune
Excel Version(s)
MS OFFICE Windows 10
Hi,

Is there any way to get the automated calendar months by the given dates if I but the date in Column A as 04-05-2018 and B as 03-05-2022 then I get the entire full months between these dates in the remaining columns starting from D
 

Attachments

  • Calendar Automation.xlsx
    10.3 KB · Views: 7
=EOMONTH(A2,SEQUENCE(1,DATEDIF(A2,B2,"M"),0,1))+1
see attached.
 

Attachments

  • ExcelGuru11161Calendar Automation.xlsx
    10.9 KB · Views: 10
Back
Top