R
ryguy7272
I am trying to get my dates in this format:
Sunday, Feb 1, 2009 to Saturday, Feb 7, 2009
This is in a TextBox on a Form. Basically, I’d like to see the current week
when I open the From. So, for today, which is Saturday, Feb 7, 2009, I’d
like to see the format above. When I open my Form tomorrow, which is Sunday,
Feb 8, 2009, I’d like to see the current week, like this:
Sunday, Feb 8, 2009 to Saturday, Feb 14, 2009
I’m trying the function below, but not getting the results I am after:
=Format(DateAdd("d",1-Weekday(Date()),Date()),"dddd") & " to " &
Format(DateAdd("d",7-Weekday(Date()),Date()),"dddd")
This shows Sunday to Saturday, with no dates.
There is probably an easier way of doing this. What am I doing wrong.
Thanks,
Ryan---
Sunday, Feb 1, 2009 to Saturday, Feb 7, 2009
This is in a TextBox on a Form. Basically, I’d like to see the current week
when I open the From. So, for today, which is Saturday, Feb 7, 2009, I’d
like to see the format above. When I open my Form tomorrow, which is Sunday,
Feb 8, 2009, I’d like to see the current week, like this:
Sunday, Feb 8, 2009 to Saturday, Feb 14, 2009
I’m trying the function below, but not getting the results I am after:
=Format(DateAdd("d",1-Weekday(Date()),Date()),"dddd") & " to " &
Format(DateAdd("d",7-Weekday(Date()),Date()),"dddd")
This shows Sunday to Saturday, with no dates.
There is probably an easier way of doing this. What am I doing wrong.
Thanks,
Ryan---