Excel table, based on the credit card transaction time, the formula to automatically calculate the billing date and repayment date? - Trademark Inquiry Complete Network

Excel table, based on the credit card transaction time, the formula to automatically calculate the billing date and repayment date?

Billing day:

=DATE(YEAR(E2) IF(AND(MONTH(E2)=12,DAY(E2)gt;11),1,0),MONTH (E2) IF(DAY(E2)gt;A2, 1, 0), 12)

Please click to enter the picture description

Repayment date:

=D2 21

Please click to enter the picture description

Related articles

How did you get the coupons for duty-free shops in Japan?

How to download Citibank hk Android phone?

Analysis and prevention of credit card risks of Agricultural Bank of China?

Can racing pigeon Anjie electronic scanner bask in the sun?

What is the definition of credit card fraud?

Arrearage of bank credit card annual fees results in bad credit record

Minsheng bank credit card mall shopping guide?

How long will the credit card expire and not be activated?

If the credit card application is unsuccessful, can other banks find the information provided at the time of application? Will the information be uploaded to the personal credit report?

I applied for China Merchants Bank credit card many times. When I applied, the bank said that I had already applied, so I can't apply again. What's going on here