View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default Custom function for weeknum to Month i got some issues with this need alittle help

No it doesn't

Thursday May 04, 2006 translates to Saturday April 29, 2006
Friday May 05, 2006 to Saturday April 29, 2006
Saturday May 06, 2006 to Saturday May 06, 2006
Sunday May 07, 2006 to Saturday May 06, 2006
Monday May 08, 2006 to Saturday May 06, 2006
etc

so you can then get the month from this surely?