Hi,

I have a relatively simple formula to consolidate a date with a text string. It works on my machine with MS Office 2007 and UK Regional settings.
Cell A1 contains a date formatted as: 2013-03-25
Cell A2 contains a text string: 1,5 weeks
Cell A3 contains a formula: ="End date is: "&TEXT(A1+(LEFT(A2;2)*7);"yyyy-mm-dd")&" (incl. "&A2&")"
Displayed result in A3: End date is: 2013-04-01 (incl. 1,5 weeks)

My colleague who has MS Office 2003 and Swedish Regional settings get the following result in A3:
End date is: yyyy-00-01 (incl. 1,5 weeks)

Any suggestions as to what could cause this?

Thanks!