Adding a statement date column

[Leone]

DatesUsed Formula

Hello,

I tried to make a new column, which contains the date of the creditcard statement. If the day of the booking date (=boekingsdatum in Dutch) is higher then 26, the date of the statement (Afschriftdatum) will be the 27th of the next month, otherwise it will be the 27th of the same month as the booking date. I used the formula in the picture above, but with the booking date 28th of march and 27th of april, april 29 and 30th of april the formula does not seem to work. For all of that dates it will return 27th of december 2023?! Can anyone help me correcting the formula?

Thanks. 

Note: dates are formatted in Dutch format: dd-m-yyyy

[amitchandak · Accepted solution]

@Leone , a new column 

if(Day([BookingDate]) >26, eomonth([BookingDate],0)+27, eomonth([BookingDate],-1)+27)