PC Review


Reply
Thread Tools Rate Thread

How do I change date to FirstDateOfTheWeek?

 
 
=?Utf-8?B?amNoZW4=?=
Guest
Posts: n/a
 
      2nd May 2007
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.
 
Reply With Quote
 
 
 
 
acampbell
Guest
Posts: n/a
 
      2nd May 2007
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)

 
Reply With Quote
 
RB Smissaert
Guest
Posts: n/a
 
      2nd May 2007
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.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
date in Cell to change colors if the date is beyond today's date Pete Elbert Microsoft Excel Misc 2 6th Jun 2009 06:31 AM
How do I change date yyyymmdd to a Excel-supported date format? dan Microsoft Excel Worksheet Functions 3 6th Jul 2008 11:05 PM
Change satellite julian date format YYYYDDDHHMMSS to excel date ti putley Microsoft Excel Misc 1 11th Jan 2008 06:12 PM
Make date change in excel to current date when opening daily? =?Utf-8?B?amFtaWU=?= Microsoft Excel Misc 3 1st Mar 2006 03:37 PM
Track change Author/Date popup shows US date format not correct regional set Wayne Zaunders Microsoft Word New Users 1 23rd May 2004 11:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:25 AM.