Skip to content

Instantly share code, notes, and snippets.

@jmakeig

jmakeig/fy-date-converter.xlsx

Created July 2, 2020 22:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jmakeig/0e731d55f948e91cfea89eff58aaaec1 to your computer and use it in GitHub Desktop.
Save jmakeig/0e731d55f948e91cfea89eff58aaaec1 to your computer and use it in GitHub Desktop.
Download ZIP
Calendar date to MarkLogic fiscal year conversion
Raw
fy-date-converter.xlsx
="FY"&IF(MONTH(G2)=1, YEAR(G2), YEAR(G2)+1) & "Q"&IF(MONTH(G2)=1, 4, FLOOR((MONTH(G2)+1)/3,1))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment