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 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 he
http://www.cpearson.com/excel/weeknum.htm

RBS

"jchen" wrote in message
...
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.