Contract Year Formula

Question

I am running into a wall trying to site a formula that kicks out the contract year. So basically i want it to check the date of a job [Job Start Date] and tell me what year of the contract it is taking place 1 thru 7. Contract started mid September so i can't use a calendar year but instead need to make a range (for example is it < 9/15/2021 but >9/15/2020.

------------------------------
Nate
------------------------------

MarkShnierYou · Accepted Answer

I think that this worksvar date AdjustYearToCalendarYear = AdjustMonth([Job Start Date],-8)-Days(14);var date AnchorDate = Date(2017,1,1);Year($AdjustYearToCalendarYear) - Year($AnchorDate) +1The formula basically adjusts the job start date backward by 8 months and 14 days to normalize it to a normal January 1st year and then is able to just subtract the year from the Year of the Anchor Date.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

MarkShnierYou · Answer

Are you trying to say that you have a fiscal year that starts in August? What are the dates for your fiscal year.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community