View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Walter Briscoe Walter Briscoe is offline
external usenet poster
 
Posts: 42
Default Weekday from text date

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