And the "dddd" is a formatting string, one that tells the Excel function TEXT to format the value in
A1 as a named date. For example, with today's date 10/24/06 in cell A1


=TEXT(A1,"0") returns 39014
=TEXT(A1,"d") returns 24
=TEXT(A1,"dd") returns 24
=TEXT(A1,"ddd") returns Tue
=TEXT(A1,"dddd") returns Tuesday
=TEXT(A1,"m") returns 10
=TEXT(A1,"mmm") returns Oct
=TEXT(A1,"mmmm") returns October
=TEXT(A1,"mmm dd, yyyy") returns Oct 24, 2006

HTH,
Bernie
MS Excel MVP


"Dave F" wrote in message
...
The answers are found with experience.

Dave
--
Brevity is the soul of wit.


"Oldjay" wrote:

Dave gave me this correct answer of

=if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date")

to my question of how to be sure an input date was on a Sunday

Where do all you experts find these answers?

Are they written down somewhere?

What does "dddd" mean?