View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aqib Rizvi[_2_] Aqib Rizvi[_2_] is offline
external usenet poster
 
Posts: 40
Default Day from year in 1 column & day & month in another

Try this

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


AQIB RIZVI