Forum Discussion
cmckernan93
Jul 29, 2022Copper Contributor
Help - Lookup based on a week ending date
Hello, I am having issues getting a table to pull the right dates - i have a source file that lookups up from a vlookup table but the week numbers don't actually match the trading weeks in real t...
Riny_van_Eekelen
Jul 29, 2022Platinum Contributor
cmckernan93 Are you using the ISOWEEKNUM function. That one returns the same values as the web site you refer to. Thus, no need to look them up.
cmckernan93
Jul 29, 2022Copper Contributor