View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter[_5_] Peter[_5_] is offline
external usenet poster
 
Posts: 8
Default 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!