Need to fill date series (monthly) in a large document

[raselkhl]

I have a large number of data in an excel sheet and I want to put monthly date like 1 to 6 January 2017 and after that 6 to 6 February 2017 then 1 to 6 March 2017 etc. and it will be continue automatically till the end.
Example:
1 A 01-Jan-17
2 b 01-Jan-17
3 c 01-Jan-17
4 d 01-Jan-17
5 A 01-Jan-17
6 b 01-Jan-17
7 c 02-Jan-17
8 d 02-Jan-17
9 A 02-Jan-17
10 b 02-Jan-17
11 c 02-Jan-17
12 d 02-Jan-17
13 A 03-Jan-17
14 b 03-Jan-17
15 c 03-Jan-17
16 d 03-Jan-17
17 A 03-Jan-17
18 b 03-Jan-17
19 c 04-Jan-17
20 d 04-Jan-17
21 A 04-Jan-17
22 b 04-Jan-17
23 c 04-Jan-17
24 d 04-Jan-17

[alansidman]

Please Login or Register  to view this content.

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button

[madhumadhan]

Hi,

First you enter All Dates in Excel used By Dropdown (For Instance 01/01/2019 to 31/12/2022). Then

01/01/2019 =Day() =IF(AND(B1>=1,B1<=6),"Okay","")
02/01/2019 =Day() =IF(AND(B2>=1,B2<=6),"Okay","")

After Copy pasting these formulas in all rows and then you can filter by Word "Okay". Now You get the Dates 01-06 From all years and All months.

[raselkhl]

Thank you very much.