I'm trying to find the next day of the powerball, It falls on each wednesday and saturday of each week. I want the out put to be in long date format so if it is a Tuesday the program would give back "Wednesday the blah blah blah" if it were thursday the program would give back "Saturday the blah blah blah" and if it is the day the program would give back "Today, Wednesday the blah blah blah" but it also needs to calculate for the month to roll over into the next. Here are some examples of what I need in and what should come out
2/24/03 then the output should be "Wednesday, Febuary 26th 2003"
2/26/03 then the output should be "Today, Wednesday, Febuary 26th 2003"
and if it is
2/27/03 then the output should be "Saturday March 1st 2003"
the last example has been my trickiest because I know Saturday is 2 days away from Thursday (2/27) but the last day of the month is the 28th
I have been working on code and getting close but no cigar, I'm at work and my code is at home so I'll post what I got so far later but just a side note this is all behind the scenes so the user will input nothing so to get the current date I'd like to use Date$ or Now() or something similar. Basiclly a function to add N amount of days to a date and include calculation for month rollovers. I can find the N amount of days away just can't produce a new correct date.
MoDrop - Ascii(13)