Convert a Date to a Day

[John]

Is it possible to have a reference date in Cell A1 - say 19/04/2005 and
Return a value in Cell B1 - Tuesday ?. I've tried =DAY(A1) but it returns 19


Thanks

 

[Don Guillett]

try
=text(a1,"dddd")

 

[John]

Thanks Don

try
=text(a1,"dddd")

 

[º¼ÖÝÈË]

weekday("19/04/2005",1)

 

[Don Guillett]

glad to help

 

[Don Guillett]

Now that you have the day number you could use a choose formula to get
Tuesday....

 

[Don Guillett]

Now that you have the day number you could use a choose formula to get
Tuesday....

 

[RagDyeR]

Why not simply:

=A1

And custom format:
dddd

?
--

Regards,

RD

 

[Don Guillett]

just as good w/o the overhead of the formula