Amex variable closing date

[Anonymous]

I noticed with Amex cards the closing date changes each month. I thought maybe they did it based off how many days have passed rather than the same date every month, but even the length of the BC changes. Is there some reason for this?

[FinStar]

That's pretty much how it's always been AmEx-wise, honestly. 

That said, there's plenty of lenders who have similar variable closing dates such as USB/Elan, BoA, WF, Comenity, SYNCB, 5/3, BBVA, Citi and countless many others. 

[Anonymous]

My due date has been slipping the last few years. Almost always the 10th, now its almost always the 8th. This month it was the 7th, understandably since its February. Maybe it stays the 7th most of the rest of the year.

Getting it back to the 10th is like having to pull up your pants lol.

[KLEXH25]

I've noticed this with Amex, as well as other lenders. Payment due date is always the same (9th for me), but statement close date varies between the 13-15th, depending on the length of the month. If you note the dates, you can pick up the pattern. At least Amex tells you when the statement closes though....unlike other lenders. 

[staticvoidmain]

I posted somewhere else about the closing dates and the formula I used in my spreadsheet. It is simple for AMEX, due date minus 25 days. If that date falls on a Saturday, move the date to the Friday before it. And this is why you have a variable date (because days of months are different, and falling on a Saturday moves it as well). Due dates are the only ones constant in a month and are usually the ones you have control over.

Here is my AMEX spreadsheet formula.

=UPPER(TEXT(
    IF(WEEKDAY(DATE(CurrentYear,MONTH(B$4),DueDateAMEX-25))=7,
        DATE(CurrentYear,MONTH(B$4),DueDateAMEX-26),
        DATE(CurrentYear,MONTH(B$4),DueDateAMEX-25)),
"MMM DD"))