RE: $$Excel-Macros$$ Re: How does the Mod operator work with dates

Dear Prince Thank you very much for the reply, now it all makes sense! Much appreciated, wish all the best for you! Best Regards Jeff Wu From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: Thursday, April 4, 2013 2:15 AM To: excel-ma

$$Excel-Macros$$ How does the Mod operator work with dates

Dear All How are you? I'm trying to learn VBA by following examples in the Excel Macro book I got. I got stuck with one of the function examples relating to using Mod operator with date. This example converts week number to a date. Please see the attached Macro for details. I'm having troub