formulas
| Formula | Description |
|---|---|
=ISFORMULA(INDIRECT("rc",FALSE))
| Cell Has Formula |
="Q"&MOD(ROUNDUP(MONTH(B1)/3,0)+2,4)+1 & " FY" & IF(MONTH(B1)>=4,YEAR(B1)&"-"&RIGHT(YEAR(B1)+1,2),YEAR(B1)-1&"-"&RIGHT(YEAR(B1),2)) | Quarter and Financial Year |
="Q"&MOD(ROUNDUP(MONTH(B1)/3,0)+2,4)+1 & " FY" & RIGHT(IF(MONTH(B1)>=4,YEAR(B1)+1,YEAR(B1)),2) | Quarter and Short Financial Year |
formulas.txt · Last modified: by admin