Day from year in 1 column & day & month in another
 

Hi guys, I am quite new to this and I am trying, without a lot of success,
to display the day of the week on which a date falls in column d from the
day number in column a, the month number in b and the year in c.
I have been playing with
=Weekday(concatenate(A1,B1,C1)

but I think this is failing because it is adding the cell contents as text!

Day from year in 1 column & day & month in another
 

Try this

=WEEKDAY(DATE(C1,B1,A1))


AQIB RIZVI

Day from year in 1 column & day & month in another
 

Many thanks Aqib, that is just the ticket

Regards
Peter
"Aqib Rizvi" wrote in message
...
Try this

=WEEKDAY(DATE(C1,B1,A1))


AQIB RIZVI