Hello guys,
I have a column of dates. I want to display the First_DATE_OfTheWeek in the
other column based on my dates. How do I do that using Formula?

Basically I want to sort my records by week, so I need dates to be converted
to the First_DATE_OfTheWeek.

Thank you for your help.

On May 2, 2:12 pm, jchen <j...@discussions.microsoft.com> wrote:
> Hello guys,
> I have a column of dates. I want to display the First_DATE_OfTheWeek in the
> other column based on my dates. How do I do that using Formula?
>
> Basically I want to sort my records by week, so I need dates to be converted
> to the First_DATE_OfTheWeek.
>
> Thank you for your help.

Take a look at the WEEKDAY function. Combine with IF to determine
whether cell contains first day of the week (Sunday or Monday)

Have a look here:
http://www.cpearson.com/excel/weeknum.htm

RBS

"jchen" <(E-Mail Removed)> wrote in message
news:68250AFD-3CCD-4D7C-9B20-(E-Mail Removed)...
> Hello guys,
> I have a column of dates. I want to display the First_DATE_OfTheWeek in
> the
> other column based on my dates. How do I do that using Formula?
>
> Basically I want to sort my records by week, so I need dates to be
> converted
> to the First_DATE_OfTheWeek.
>
> Thank you for your help.