Format Dates: Sunday, Feb 1, 2009 to Saturday, Feb 7, 2009

  • Thread starter Thread starter ryguy7272
  • Start date Start date
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---
 
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.
Click to expand...

Your format expression is not set up to show dates, only days.

Format(SomeDate, "dddd")

....will only give the day of the week. You need...

Format(SomeDate, "dddd, mmmm yyyy")
 
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.
Click to expand...

It's giving you precisely what you asked for: dddd is the format expression
for the written-out day of the week.

Try using a format of

"dddd, mmm dd, yyyy"

to get the day name, abbreviated month name (mmm), day number (dd) and year.
 
Wow; pretty slick!! I went with this:
=Format(DateAdd("d",1-Weekday(Date()),Date()),"dddd, mmmm dd, yyyy") & " to
" & Format(DateAdd("d",7-Weekday(Date()),Date()),"dddd, mmmm dd, yyyy")

Thanks Rick and John!!


Regards,
Ryan---
 
Back
Top