Making a date out of three columns that are not necessarily filled.

[mawilson12]

I have a spreadsheet of Civil War veterans which I am trying to get into genealogy software. Converting into real dates is the first task. If I have an Excel spreadsheet that has Column D2 as a day of the month, E2 as the number month of a year and F2 is a year, what formula do I use to have a cell with the date expressed as (d)d/MMM /YYYY compensating for cells that may not have a day or month? Ideally if the day or month is missing, just do month/year or year accordingly. Otherwise, as close as I can get will be fine, even if the date is 1/1/Year.

 

[Peter_SSs]

No, as at the time I was on a work computer, if you must know. No need for you to be a smart-aleck about it.

I apologise if I offended you in any way. I was definitely not trying to be a smart alec. Your earlier response sounded like you only stopped trying to install XL2BB because of the message that you received, not because of a work situation, and I was simply trying to reassure you that it should be safe to install.

Anyway, it looks like you have a suggestion that suits you for the problem and that is the main thing.