4 Replies Latest reply on Mar 16, 2016 3:47 AM by Steve Martin

# Find fiscal year starting on first Sunday of December

Hi,

I have a date field and I am trying to find out the fiscal year for the same. I am currently using the following formula so as to get the fiscal year:

IF MONTH([Date])=12 THEN  YEAR([Date])+1

ELSE YEAR([Date]) END

But my fiscal year calendar starts every first Sunday of every December. Please help me modify the formula so as the get the fiscal year.

• ###### 1. Re: Find fiscal year starting on first Sunday of December

Hi Sidhu,

It looks as though you only need to add a second step into your calculation maybe focussing the source to the first week and then identifying the Sunday.

First week would be

Day(Date) >= 1 And Day(Date) <=7

And now for the day

DateName('weekday',Date)

So I would expect your calc logic to be something like

If Month(Date) = 12 And (Day(Date) >=1 And Day(Date) <=7) And DateName('weekday',Date) = 'Sunday' Then Year(Date)+1 Else Year(Date) End

Note, I placed the week check into its own sub calc to enable this to be evaluated separately.

Steve

1 of 1 people found this helpful
• ###### 2. Re: Find fiscal year starting on first Sunday of December

Thanks Steve. It works.

• ###### 3. Re: Find fiscal year starting on first Sunday of December

Steve

• ###### 4. Re: Find fiscal year starting on first Sunday of December

Hi Sidhu,

To prevent this from continuing to pop-up as not answered, please can you mark this as answered / correct.

Steve