View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Weekday from text date

0516 is not a date and you cannot calculate the day of the week from it as
it doesn't contain any reference to the year. You may know that the year is
2010, but the PC cannot read your mind.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Walter Briscoe" wrote in message
...
Strictly speaking, this is not topical.

I run Word & Excel 2003 and have an Excel data source, giving me grief.

I have a text field (B2) containing a date. e.g. for today, it has 0516
meaning Sunday, May 16, 2010.
Another date field (C2), set to =TEXT(B2,"dddd"), has value Thursday and
I want the value Sunday.
When B2 is 1, =TEXT(B2,"mmm-dd-yyyy") has value Jan-01-1900. i.e. My
number is taken as the date offset by Jan-01-1900.

What hopefully simple formula should I put in C2 to calculate Sunday
from 0516 in B2. =TEXT(B2 + 1st January this year, "dddd") is tortuous.

I have freedom to change anything, but am attached to my "mmdd" date.
I would really prefer not to change my Word document.

Thanks!
--
Walter Briscoe