With a worksheet set up as below. The formula in C2 would be: =VLOOKUP(MONTH(B2),$F$2:$G$13,2,0) &" " & YEAR(B2) and copied down


Data Range
A
B
C
D
E
F
G
H
1
Start
End
Billing Month
2
12/26/2018
1/25/2019
January 2019
1
January
3
1/26/2019
2/25/2019
February 2019
2
February
4
3
March
5
4
April
6
5
May
7
6
June
8
7
July
9
8
August
10
9
September
11
10
October
12
11
November
13
12
December