Dynamic Pivot Table-Excel Formula

                                          

Insert Rows & Columns-Macro Coding

Below is the code to insert Row by VBA in excel

ActiveSheet.Range("b1").EntireRow.Insert

Below is the code to insert Column by VBA in excel

ActiveSheet.Range("b1").EntireColumn.Insert

EOMONTH()

The below formula will help you get the last day of the month for the date you select.

=EOMONTH(cell,0)

Cell : Cell is cell containing dates.

If you want previos months last date than -1 instead on 0.
Same way for next month +1.

Fiscal Year/ Financial Year- Excel Formula

Please Read the whole Explanation to understand better.

Below is the Excel formula for getting Fiscal Year for the date you want in the formulated cell.

=Year(Date(Year(cell),Month(cell)+9,1))

Cell : Cell in the above formula refers to the cell containing the date for which we want the fiscal year.

The above formula is for fiscal year from 1 apr - 31 mar.

After month we have added 9 because after march i.e. last month of our fiscal year there are more 9 months left to complete the celander year.

Copy Paste Macro- Macro Formula