Fiscal Week / Month / Year

Greetings All!

I am stumped trying to get a Grid to formulate for Fiscal Dates. I am trying to report out and showcase on a Dashboard what has been done This Week (Sun - Sat) , Last Week, This Month, and This Quarter. I have tried several IF, DATE, and various other formulas. I have the report aspect fine, as well as the Dashboard, but the Fiscal timing has been my barrier so far! I have read several other questions, but nothing has helped, so any help/advice would be appreciated!!

Find more posts tagged with

Accepted answers

Mark Cronk

Try:

= IF(WEEK(date@row)=WEEK(TODAY()), "This Week", IF(WEEK(date@row)=WEEK(TODAY(7)), "Next Week", " -"))

Unparsable usually means there's a paren or comma out of place. I found a missing ".

Work this time?

Mark

All comments

Mark Cronk

Hi @Steve Ketterer ,

Is this what you're looking for? Replace my date@row with your date column name:

This week is :

IF(WEEK(date@row)=week(today()), "This Week",

Next week is:

IF(WEEK(date@row)=WEEK(TODAY(7)), next week",

Quarter is:

IF(MONTH(date@row)>8,"4Q", IF(MONTH(date@row)>5, "3Q", IF(MONTH(date@row)>3, "2Q", "1Q")))

Help?

Mark

Steve Ketterer

Hi @Mark Cronk!

I am sorry for the delay in my response as I was out on my weekend.

I tested all the formulas, and all come back Unparseable. I have tried slight variations to that, but I am not even seeing a "Week" Formula, and I have tried WEEKDAY, and WEEKNUMBER to adjust, but to no avail.

However the Quarterly one has worked perfectly! Thank you for that one!

If you have anymore insight on the Fiscal Week problem, please let me know!

Thank You!

Steve

Mark Cronk

Try:

= IF(WEEK(date@row)=WEEK(TODAY()), "This Week", IF(WEEK(date@row)=WEEK(TODAY(7)), "Next Week", " -"))

Unparsable usually means there's a paren or comma out of place. I found a missing ".

Work this time?

Mark

midniterodeo

I like these formulas for fiscal date information. How do you get the Fiscal Month along the same lines?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.