converting date to day

  • Thread starter Thread starter rajgopal
  • Start date Start date
R

rajgopal

How can I canvert date (e.g. 3/17/2004) into day? I tried custo
formatting, it works. But when I try to sort the coulmn that has da
values, it sorts based on the underlying date. Any help
 
With a formula you can use
DAY(A1) for 17
or
WEEKDAY(A1) for 4 (wednesday)

then you can sort on that column.
 
You need another column otherwise you still have that date.

Put =TEXT(A1,"dd") in B1 and sort by that column.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
one way: you may add a helper column with the following formula (if
your dates are in column A)
=TEXT(A1,"dddd")
and copy down
use this column as sorting criteria
 
Back
Top