Sales Amt Calculation based on CY and LY

[#1]

Hi all,

I want to calculate Sales Amount for the attached excel file.

Condition : It has data up to Aug 2014. So need to calculate Amt for Aug 2013 to Jul 2014.

When Sept 2014 comes, Amt for Sept 2013 to Aug 2014.

Regards,

Sivasu

[VishalWaghole]

Hi,

PFA application, Hope it will work for you.

-- Regards,

Vishal Waghole

[#3]

Thank You so Much.

Please can you say me to caluclate the same condition based on Financial Year and Financial Month.

Regards.

Sivasu

[VishalWaghole]

What you want exactly with finance Year and Month...

Clarify you requirement.

-- Regards,

Vishal Waghole

[#5]

Your Logic works fine for Calendar Year and Calendar Month.. But the same condition for Financial Year and Financial Month.

[#6]

If i select Financial Year and Financial Month as 2014 and April. In NewMonthName field, it is selected as Jan2014.

Regards,

Sivasu