Inserting rows with entry of month and dates of two given months

Status
Not open for further replies.

jassi2006

New Member
Joined
May 3, 2020
Messages
10
Office Version
  1. 2019
  2. 2016
  3. 2007
Platform
  1. Windows
  2. Mobile
  3. Web
Hello Excel Warriors

I am working and trying but failed to achieve the goal.

I want to create an VBA program to create Excel sheet to calculate arrear of pay.

I just want to create list of months automatically between start and end dates in which if the starting date or the end date have only dates then it comes as date from to. Here is the example
If given date is 12-03-2020 to 25-06-2020

Then the result is
12-03-2020 to 31-03-2020
04-2020
05-2020
01-06-2020 to 25-06-2020

OR it will also be ok
12-03-2020 to 31-03-2020
01-04-2020 to 30-04-2020
01-05-2020 to 31-05-2020
01-06-2020 to 25-06-2020

Please help !!
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,299
Messages
5,571,408
Members
412,388
Latest member
Meistermacher
Top