DAYS

[brumby]

Hiya,

I have a range of dates ( DD/MM/YY ), is it possible in the adjacent colum, show the DAY name eg :-

A1 = 27/01/04 - B1 Would = THUR


is this possible?

Cheers

 

[shades]

=TEXT(A1,"ddd")

Adjust the number of ddd's

 

[Oaktree]

If you want THU, try = text(A1,"ddd")

For THUR, you'd need something like =UPPER(LEFT(TEXT(A1,"dddd"),4))

 

[brumby]

MANY THANKS......works a treat,


also.......can you generate a date from a weeknumber, eg :-

WEEKNUMBER 4 - Return 24/01/05 ( 24th being 1st day )


Cheers

 

[Oaktree]

Try the WEEKNUM function (part of the analysis toolpak)