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.
[IMG alt="Name: 2020-09-10_15h38_49.png
Views: 0
Size: 10.0 KB"]Excel Help Forumsample.xlsx
[IMG alt="Name: 2020-09-10_15h39_56.png
Views: 0
Size: 13.5 KB"]Excel Help Forum
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.
[IMG alt="Name: 2020-09-10_15h38_49.png
Views: 0
Size: 10.0 KB"]Excel Help Forumsample.xlsx
[IMG alt="Name: 2020-09-10_15h39_56.png
Views: 0
Size: 13.5 KB"]Excel Help Forum