date issue

[ahhhmed]

I have three cells

A1, B1, C1, D1


In A1 I write the month

in B1 I write the date of the day

in C1 I write the year

How can I make excel put the day's name in D1?

 

[Mike86]

=text(Date(c1,a1,b1),"dddd") will work

 

[pacochin]

Hi,

Assuming below :

A1 = 01

B1 = 31

C1 = 2011

D1 = Date(C1,A1,B1) .... then format it as Custom "DDD"


is this what you want?

 

[ahhhmed]

thank you, all