View Single Post
  #4   Report Post  
trinity
 
Posts: n/a
Default Forumla for converting dates into days


Is there a way to get this added to a new row automatically when the new
row is created (eg by pressing tab at the end of the last row)?

macropod Wrote:
Hi Jim,

Simply bookmark the date (not the cell!) in column B, then use a ref
field
in Column C to extract the date. For example:
If the date in B1 is August 12, 2005, and you bookmark this as
'B1Date',
then you'd use a REF field in C1 coded as:
{REF B1Date \@ dddd}. This should return 'Friday', not 'Monday' as
indicated
in your post ...

Cheers
PS: The field braces (i.e. '{}') are created in pairs via Ctrl-F9.
Alternatively, you can create the REF field via Insert|Field.


"Jim" wrote in message
...
I have a table in a works document. In columnn 1, I have topics, in
column 2
is the date (ie August 12, 2005), column 3, is to show the day of
the
week
(ie Monday)

PLease help!!!!!



--
trinity