Date format in string

A

Adam Thwaites

I have this code:
="Week Beginning " & Date-WEEKDAY(Date,3)
which I can't stop coming out as:
Week Beginning 38719

I tried:
="Week Beginning " & format((Date-WEEKDAY(Date,3)),"dd" & "/" & "mm" & "/" &
"yyyy")
but that just comes up as #NAME

Any suggestions?
 
B

Bob Phillips

="Week Beginning " & text(TODAY()-WEEKDAY(TODAY(),3),"dd mmm yyyy")


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
G

Gary''s Student

Consider using TEXT():


="Week Beginning: " & TEXT(TODAY()+4,"dd/mm/yyy")
will display as:
Week Beginning: 14/05/2006
 
Top