|
Posted to microsoft.public.excel.programming
|
|
|
How do I change date to FirstDateOfTheWeek?
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.
|