View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] drolfe@nelsonwatson.com is offline
external usenet poster
 
Posts: 3
Default Wierd Bug with Format Date VBA???

sub stuff()
theDate = Format(Now,"mm-dd-yy")
themonth = Month(theDate)
theDay = Day(theDate)
wkday = Format(theDay, "ddd")
end sub

..... for some reason when i use the Format() function, it takes the day
before. Is there an option statement that I am missing or something?
The first format string returns the correct day, but the second one
returns the previous day. Am i missing an option statement?