79319379

Date: 2024-12-31 07:14:43
Score: 3
Natty:
Report link

=IF(DAY(B2)>10, MONTH(B2), MONTH(B2)-1)

If date is in cell B2.Try it.

Reasons:
  • Low length (1.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: RAJKUSHDEV