View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default please explain

Try this...

dayofweek = Format(30 - 4 - 2009, "Dddd")
--
HTH...

Jim Thomlinson


"sunilpatel" wrote:

dayofweek = WeekdayName(Weekday(30 - 04 - 2009))

why is Friday returned not Thursday.