chaosincarnate
New Member
I am having an issue getting a date formula to correctly work.
Starters - some information is in "Company B" for reference.....
I created this a few years ago to track mandatory Urinalyisis testing. In Tab "Company B" Colums F-H does a quick look up to match what is entered in Column B(type of person being tested by their position). Totals it up in row 181-185...works fine so far no issues that I have noticed...
My issue seems to be column J. It should give a correct date for the Quarters...Now understand 1 October is 1st quarter for us.. 1 January starts 2nd Quarter..etc...
Colum J should give a result in J2 as 1 Oct 14 but instead its 1 Oct 13. I played with the formula and can force it show what I want but as 2015 comes around it will not be accurate any more. Similar issues in J3-J5.
Once everything is computed it should place the corect numbers in tab "Rollup" in the correct Quarters...however its not. Placing 1st quarters in 4th Quarters. A simple fix is instead of having a formula I can just change the date every year(J2 = 10/1/2014, J3 = 1/1/2015, etc..) but i dont want to. I want it to update itself with out manually entering a new date yearly. It worked great in the past but recently it was noticed it was placing things in the wrong quarters in the rollup tab. All "Company tabs" are the same just linked to their respective company on the rollup tab.
Sorry if this sounds confusing...in my mind it sounds logical...
I'm illiterate in VB, macros, and alot of the more detailed formulas of EXCEL.
Starters - some information is in "Company B" for reference.....
I created this a few years ago to track mandatory Urinalyisis testing. In Tab "Company B" Colums F-H does a quick look up to match what is entered in Column B(type of person being tested by their position). Totals it up in row 181-185...works fine so far no issues that I have noticed...
My issue seems to be column J. It should give a correct date for the Quarters...Now understand 1 October is 1st quarter for us.. 1 January starts 2nd Quarter..etc...
Colum J should give a result in J2 as 1 Oct 14 but instead its 1 Oct 13. I played with the formula and can force it show what I want but as 2015 comes around it will not be accurate any more. Similar issues in J3-J5.
Once everything is computed it should place the corect numbers in tab "Rollup" in the correct Quarters...however its not. Placing 1st quarters in 4th Quarters. A simple fix is instead of having a formula I can just change the date every year(J2 = 10/1/2014, J3 = 1/1/2015, etc..) but i dont want to. I want it to update itself with out manually entering a new date yearly. It worked great in the past but recently it was noticed it was placing things in the wrong quarters in the rollup tab. All "Company tabs" are the same just linked to their respective company on the rollup tab.
Sorry if this sounds confusing...in my mind it sounds logical...
I'm illiterate in VB, macros, and alot of the more detailed formulas of EXCEL.