Oct 23, 2012 at 05:47 PM

Problem with Excelsius

20 Views

Hi All,

Can you kindly help on this below Spreadsheet issues:

Lets Assume : A Table has this formats of column datas eg: 02/2010

My desired outcome in the ComboBox Component should be in Periods like 3months, 6months and so. How can this be achieved.

To add to the above issue i was facing the below issues too like:

1) Now I want to know the Current Fiscal Year which this month is in? How can i do this.

2) If suppose I want to get Previous Fiscal Year which this month is in? How can i do this.

3) Finding The Quarter Period Of this like 02/2010. Considering problem encountering is when the year changes

4)
Assuming the fiscal year is 2008, the quarters are as follows:

1st QTR = 07/2007 - 09/2007
2nd QTR = 10/2007 - 12/2007
3rd QTR = 01/2008 - 03/2008
4th QTR = 04/2008 - 06/2008

When 07/2007 is entered, the result should be Q1-2008, The problem i am encountering is when the year changes. How shall we do this in excel by using formula's
and do i need to consider in the formula if the range of these months(say eg:January-September) falls between year

5)How do i convert the Convert Fiscal Date To Corresponding Week Number

6) say eg: My Financial year runs from Oct to Sept. My current month is June 2008 and the YTD Expenses is in Cell xyz..I have set up a formula to calculate the prior YTD Expenses?