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)