Hello Everyone,
I am new here and I really need some help,
I believe my problem is issue but i really dont know the formula,
just need the result
IF date is between 1-15th of the month = result 1st date of the following month
IF date is between 16th-31st of the month = result 16th date of the following month
sample:
(PAYMENT) Date 08/05/2020 = result 09/01/2020
(PAYMENT) Date 08/17/2020 = result 09/16/2020
I have attached all the screenshots.
2020-09-10_15h38_49.pngsample.xlsx
2020-09-10_15h39_56.png
Thanks everyone
Bookmarks