On Sun, 30 May 2010 14:26:01 -0700, sort
wrote:

How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
is given by "dddd" but I need the reverse process. I would be open to the
numbers of the Day of Week too.

I am given the:
mm=11
dd=15
yyyy=2009

find
dddd or number of the Day of Week

The formula
=WEEKDAY(DATE(2009,11,15),2)
returns the value 7, indicating that November 15, 2009 was a Sunday.

Hope this helps / Lars-Åke