ExcelBanter - how do I join month(#) in col a and day(#) in column b to a date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I join month(#) in col a and day(#) in column b to a date? (https://www.excelbanter.com/excel-discussion-misc-queries/102318-how-do-i-join-month-col-day-column-b-date.html)

unikpaul

how do I join month(#) in col a and day(#) in column b to a date?

As I have e.g. 2 in col A and 5 in col B I would like to join the 2 numbers
to the date 2/5 in col C.

daddylonglegs

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

All times are GMT +1. The time now is 11:04 AM.