Date format in string
One way:
="Week Beginning" & TEXT(Date-WEEKDAY(Date, 3), "dd/mm/yyyy")
In article ,
Adam Thwaites wrote:
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?
|