Hi there,

The Indian financial year starts from 01st April & ends at 31st March of the corresponding year. I want to compare the sales data of parties over the last 2 'indian financial years'. By default Excel 2010 arranges the data according to the calendar year (1st Jan to 31st December) year wise i.e. 2009, 2010, 2011, etc.

How can I manage this? I want date range from 01/04/09-31/03/10 & 01/04/10-31/03/11 & 01/04/11-Current in different columns. Please advise.

Cheers!