Date: Monday, beginning of week

[XLerator]

Is there a date formula that always has the current week's (Sunday though Saturday) monday day in a cell...

So each week, that cell would represent the Monday of the week.....

Basically the reason why I want this is because I want to type this is for example.

"Monday, May 27 to TODAY'S DATE"

any ideas??



[ This Message was edited by: XLerator on 2002-05-26 13:55 ]

[Aladin Akyurek]

On 2002-05-26 13:46, XLerator wrote:
Is there a date formula that always has the current week's (Sunday though Saturday) monday day in a cell...

So each week, that cell would represent the Monday of the week.....

Basically the reason why I want this is because I want to type this is for example.

"Monday, May 27 to TODAY'S DATE"

any ideas??



[ This Message was edited by: XLerator on 2002-05-26 13:55 ]

Enter =TODAY() say in E1 then use:

=E1+(2=WEEKDAY(E1))*(2-WEEKDAY(E1))


[ This Message was edited by: Aladin Akyurek on 2002-05-26 13:58 ]

[Yogi Anand]

I am not quite sure how are you considering the makeup of the week ... I have made the assumption that your week begins on Monday and ends on Sunday ... so Sunday May 26 is part of the week of Monday May 20 to May 26.
If this is true, then use

=TEXT(E1- (WEEKDAY(E1,2)-1),"dddd mmmm dd")&" to "&TEXT(TODAY(),"mmmm dd")

otherwise use

=TEXT(E1- (WEEKDAY(E1,2)-8),"dddd mmmm dd")&" to "&TEXT(TODAY(),"mmmm dd")

Regards!

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 12:51 ]

[Dave Patton]

Try the following. Edit the wording and formatting for your preferences.

="From "&TEXT(TODAY()-WEEKDAY(TODAY(),3),"ddd dd-mmm-yyyy")&" to "&TEXT(TODAY(),"ddd dd-mmm-yyyy")

[Mark W.]

=TEXT(TODAY()+TREND({1,0},{1,2},WEEKDAY(TODAY())),"dddd, mmm dd")&" to TODAY'S DATE"