fiscal year

🤓 Good day my fellow nerds, Today I need guidance on how to figure out the Week Number based on the day. Let me breakout a list of things you will need to know: - The Week # being displayed will be based on the United States Government Fiscal Year 2023 which is: 1st quarter: 1 October 2022 –...

I'm trying to convert a historical date to the same date in U.S. Government fiscal year 2022 and could use some help with the formula. For illustration, I've provided below a sample historical date which I want to convert to the same date in FY22. Sample historical date: 07/23/01 Fiscal year...

Hi all, I found formulas to calculate the fiscal year, but I'm trying to figure out a dynamic formula that will calculate if a date is within the current fiscal year (fiscal year for me starts in August). For example, I would like the result to show the following for these dates...

I've been working on a VBA macro to clear the contents of certain month columns if they are in the current fiscal year or past fiscal year. I've gotten the variables and fiscal years to calculate correctly based on the July to June fiscal year, I just can't seem to figure out the correct...

Hello, I am using a pivot table to summarize some date information (about 25,000 lines). I want to pull it by our fiscal year which runs from July to June, but the default is January to December. Is there any way to set it up to pull, for example, July 2016 to June 2017, as a year? Thanks,

<tbody> Date Quarter FY Intended Results in column "C" 15-07-2018 1 1905 2018 10-09-2018 1 1905 2018 04-11-2018 2 1905 2018 14-03-2019 3 1905 2018 10-05-2019 4 1905 2018 20-12-2018 2 1905 2018 Detail...

When you open the spreadsheet there is no date in Column Q. I've put in code to auto fill Column Q with a Now() structure. I then coded Column A to look at Column Q and if empty to take the date in Column Q and to make Column A to show "FY18 Budget Authority" based on the date in Column Q. When...

Hi all, I have an formula today that I use to calculate the FY week number. The problem is that with my table, 80k+ rows and expanding, this is a very slow process. Does anyone have an suggestion on how to speed up this formula? =WEEKNUM(A2,1)-26+IF(MONTH(A2)<7,52,0)

Here are my three formulas: in R6: =IF(K6="","",CHOOSE(MONTH(K6),2,2,2,3,3,3,4,4,4,1,1,1)) in Q6: =IF(K6="","",YEAR(K6)+IF(MONTH(K6)>=10,1,0)) in P6: =IF(Q6="","",("Q"&R6&" "&"FY"&Q6)) R6 finds the Fiscal Quarter of the date in K6 Q6 finds the Fiscal Year of K6 P6 combines the two results...

First of all: best wishes to all the geniussus (i.e. you, yes you know who you are). I was wondering if any of you has had this challenge before. I'm trying to do a date calculation in a fiscal year. I have a date (1-26-2010) and want to add a number of days (90) I then want to round down to...