Dtyjlui

I have a credit card and I cannot figure out the relationship between billing cycles and/or payment dates. I am trying to set up an excel sheet to project out everything but I want it to match up with the statements I get each month and not have to change the dates every single month.

So the closest I seem to have come up with is the fact that you add the next months number of days to the this months end of cycle date to get the next end of cycle date (except the 1st month). When I tried to find a relationship with the previous months end of statement date and the following payment date, it just seemed like the days decreased by 1 every month.

The below info is straight off the statements:

So I made some initial purchases:

Original Purchase Date (1): 9/9/18

End of Cycle (E.C) # 1: 9/14/18 (29 days in Billing Cycle(B.C.))

[Payment was not required this month.]

Then I made another purchase (and payments began):

Original Purchase Date (2): 10/4/18

E.C # 2: 10/16/18 (32 days in B.C.)

Payment Day (1): 10/8/18

No additional purchases:

E.C. # 3: 11/15/18 (30 days in B.C.)

Payment Day (2): 11/8/18

E.C. # 4: 12/16/18 (31 days in B.C)

Payment Day (3): 12/7/18

Thank you so much for the help!