Excel MVP Michael Alexander wrote in with a tip on calculating week numbers. It's always a little embarrassing when you roll your own Function to achieve some functionality that already exists in Excel or Access. Recently,
Windows 7 Product Key, I stumbled across a user-defined function designed to find a week number in Access. I asked the owner of this code why he wrote a function to do this when Access has one. He gave me the 'thousand-yard stare',
Office Professional 2007, then he went on to explain that he couldn't find the WEEKNUM function in Access. You can find Michael’s solution on his Excel and Access blog. Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div