convert date into day of the week

**legolas** · 05-10-2010, 06:13 AM

Hello all,

suppose i got in A a date format only example :

11/03/2010
13/03/2010
10/04/2010
09/05/2010
08/05/2010

how do i get in B day of the week if the date match is only for saturday or saunday ?

thank you

**daddylonglegs** · 05-10-2010, 06:26 AM

If you have a date in A2 then this formula in B2 will give you the day of the week

=TEXT(A2,"dddd")

If you only want to show that if the date is a weekend date then try

=IF(A2="","",IF(WEEKDAY(A2,2)>5,TEXT(A2,"dddd"),""))

edit: or shorter version.......

=TEXT(A2*(WEEKDAY(A2,2)>5),"dddd;;")