79578220

Date: 2025-04-16 22:38:10
Score: 2.5
Natty:
Report link

Fiscal year start on 01-Jul(01-07) which calendar year start on 01-Jan(01-01) so FY start after CY date about 6 months(1-7)

= DATE(YEAR(EDATE(A2, 1-7)), 7, 1)

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