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

2013-04-05 Thread Jeffrey Wu
-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How does the Mod operator work with dates Hi jeff Wu In excel every date has some number corresponding to it it. and it start at the date "01-jan-1900" for this date the number is 1 and for the date "02-jan-1900" th

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

2013-04-03 Thread Prince
Hi jeff Wu In excel every date has some number corresponding to it it. and it start at the date "01-jan-1900" for this date the number is 1 and for the date "02-jan-1900" the number is 2 and so on. so whenever we do any calculation first the date is converted into its corresponding number and