| Code | Formula | Description |
| EF005 | =ISFORMULA(INDIRECT("rc",FALSE))
| Cell Has Formula |
| EF004 | ="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 |
| EF003 | ="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 |
| EF002 | | Tax Period in “MMM-YYYY” |
| EF001 | =DATEDIF(B1,A1,"Y")&" Years, "&DATEDIF(B1,A1,"YM")&" Months, "&DATEDIF(B1,A1,"MD")&" Days"
| Date Difference in Years Months and Days |