Results 1 to 3 of 3

Thread: How to automate calendar in excel by the given criteria

  1. #1
    Acolyte dinesh.sarsar's Avatar
    Join Date
    Sep 2014
    Location
    India, Maharashtra Pune
    Posts
    20
    Articles
    0
    Excel Version
    MS OFFICE Windows 10

    How to automate calendar in excel by the given criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,949
    Articles
    0
    Excel Version
    365
    =EOMONTH(A2,SEQUENCE(1,DATEDIF(A2,B2,"M"),0,1))+1
    see attached.
    Attached Files Attached Files

  3. #3
    Acolyte dinesh.sarsar's Avatar
    Join Date
    Sep 2014
    Location
    India, Maharashtra Pune
    Posts
    20
    Articles
    0
    Excel Version
    MS OFFICE Windows 10
    Thank you sir,

    This is awesome, thanks for your help

    You are Grate

    Love you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •