Thread: how do I join month(#) in col a and day(#) in column b to a date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default how do I join month(#) in col a and day(#) in column b to a date?

In excel you can't have a date without a year (although it can be
displayed without) so, assuming this year. Assuming you mean 2nd May
not 5th Feb then in C1

=DATE(YEAR(TODAY()),B1,A1)

format how you like


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=566797

Reply With QuoteReply With Quote