[Solved] Formulas for returning desired date

[jstack]

Assume I have the date 4/22/20 in cell A1. I want to use an IF formula in A2 to look at the date in A1 and IF the date is greater than a specific date of the month (example: MM/08/YY), then equal A1 plus 1 month. Otherwise equal A1. I tried the following:
=IF(A1>MM/08/YY;DATE(YEAR(A1);MONTH(A1)+1;DAY(A1));A1)
The above formula did not work. The month and year are irrelevant, that's why I used MM and YY rather than actual.

[Villeroy]

Of course it does not work because MM/08/YY is wild guessing. The solution can be found in the other part of the formula where you calculate next month's date correctly using the DATE function.
May be you want something like:
=IF(DAY(A1)>8;DATE(YEAR(A1);MONTH(A1)+1;DAY(A1));A1)
or
=IF(A1>DATE(YEAR(A1);MONTH(A1);8);DATE(YEAR(A1);MONTH(A1)+1;DAY(A1));A1)

[jstack]

Thank you Villeroy, that worked perfectly. I'm also having trouble with another similar issue. Is there a way to look at the date in A1 and return the next Friday date following the date in A1? Thank you!

[Villeroy]

=WEEKDAY(A1) returns a weekday number between 1 (Sunday) and 7 (Saturday).
=A1-WEEKDAY(A1) returns the Saturday before A1.
=A1-WEEKDAY(A1)+6 returns the next Friday after that Saturday. In case of a Friday it returns the same Friday.

[John_Ha]

See Calc Functions listed by category for definitions of all functions and examples of their use or check the Calc Guide.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.