vba code for between dates arrange into two columns

[Mrm_2022]

I want the vba code or normal excel program to arrange the dates between 13-01-2022 to 17-05-2022 in particular column as 13-01-2022 to 31-01-2022 in first row and 01-02-2022 to 28-02-2022 in the second row in the destination column so on... in Ms Excel as detailed below. Sir, kindly help me. Problem​ To be split and shown as in two columns​ dates between​ from​ to​ 13-01-2022 to 17-05-2022 13-01-2022​ 31-01-2022​ 01-02-2022​ 28-02-2022​ 01-03-2022​ 31-03-2022​ 01-04-2022​ 30-04-2022​ 01-05-2022​ 17-05-2022​

 

[vletm]

Mrm_2022
Something like this ...?
Write Your used dates in yellow cell and press [ Do It ]-button.
If those Bold and Underlined are needed then let me know that.

 

[Mrm_2022]

Mrm_2022
Something like this ...?
Write Your used dates in yellow cell and press [ Do It ]-button.
If those Bold and Underlined are needed then let me know that.

Thank you very much Sir, But i want the formula to use in my excel sheet in N number of times.
Further, I asks between the dates as 04-07-2021 to 31-07-2021 it shows in two rows 04-07-2021 to 31-07-2021 in the first row and 01-08-2021 to 31-07-2021 in second row.kindly suggest me to clear my doubt.

 

[vletm]

Mrm_2022
Your But i want the ...
... but You wrote I want the vba code or normal excel program to arrange the dates between...
Did You mean ... and ... ?

 

[Mrm_2022]

I WANT TO RETURN THE PAY /REVISED PAY AS DETAILED BELOW:-
FROM THE PERIOD from 01-04-2019 TO 12-07-2019 AS Rs. 20000,FROM THE PERIOD 13-07-2019 TO 31-03-2020 AS Rs.21200,from 01-04-2020 to 17-8-2020 as Rs.21800 as per pay ranga so on..

 

[vletm]

Mrm_2022
Above Your seems to want something else than Your original want.
Please, avoid to use so many capital letters.
This thread is closed now
- You seems to open a new thread ... and deleted it few seconds later.