Thread: Combine as Date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leslie W. Leslie W. is offline
external usenet poster
 
Posts: 5
Default Combine as Date

Mike,

That's exactly what I'm looking for. Thanks!

Leslie


"Mike H" wrote:

What about

=DATE(A2,B2,C2)

Mike

"Leslie W." wrote:

Hello!

I have a file that has Year in one column, Month in a second column, and day
in the third column. I would like to combine this to be a date.

Basically, is there an equivalent of the DATESERIAL SQL function in Excel?

Thanks!
Leslie