I have a code in VBA (Excel) where I am taking the fiscal month into a excel report with the code below. The problem is with the fiscal calendat (attached) where for 02/26/2011 the fiscal month should be March and not february as it is showing as per the code below. Any help to correct the fiscal month on the excel report code below will be appreciated.
Private Sub Headers()
If SheetName = "Maturity" Then
Range("O4").Value = Format(ReportDate, "MMMM")[
Range("R4").Value = ReportDate
Range("M4").Value = Format(ReportDate, "MMMM")
Range("P4").Value = ReportDate