Fentonizer wrote:I am the vlookup king.
=--TEXT(REPLACE(REPLACE(IF(LEN(F1)=5,CONCATENATE(0,F1),F1),5,2,(LEFT(IF(LEN(F1)=5,CONCATENATE(0,F1),F1),2))),1,2,(RIGHT(F1,2))),"00\/00\/00")
04/01/2013 Friday 28/02/2013 Thursday 09/01/2013 Wednesday 09/01/2013 Wednesday 22/03/2013 Friday 24/01/2013 Thursday
=VLOOKUP(WEEKDAY(E24,2),DAYS,2,FALSE)
=TEXT(E3,"DDDD")
It looks like you're new here. If you want to get involved, click one of these buttons!