Forum Discussion
MichelleChapman
7 years agoQrew Assistant Captain
That's what it looks like based on the other formula that doesn't have the right start date...not the new ones you are trying to help me understand...
QuickBaseCoachD
7 years agoQrew Captain
The formula above will not give you are correct answer. My formula will work, but I'm a QSP (Quick Base Solution Provider), so its hard to find the time to walk you though basic Quick Base formulas. That is why you may need to books some time with me or else take some of the QuickBase University courses about formula building.
If I find the time I can post a single formula to provide you with the Week number but I did the formula in a way that allowed for testing various dates so that is why there are three fields. One for the date to test, on for the first Saturday of the year and one for the Week number.
If I find the time I can post a single formula to provide you with the Week number but I did the formula in a way that allowed for testing various dates so that is why there are three fields. One for the date to test, on for the first Saturday of the year and one for the Week number.