create a date from year, day and month

B

Baerbel

I have an excel table that contains seperate rows with year, month and day of
a measurement as integer numbers - so for example the numbers 2004, 11, 13
would code Nov-13, 2004. Is there an easy way to create the date from the
year/month/day numbers?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
Extract Month and year from Cell containing date, month, year & time 2
Search closest day in the past from today 2
Calendar Logic: Recurring Dates 3
Unhide column difficulty 3
Excel PRICE function: How does it compute Issue Date of the Security 5
Excel Formula for years and months 2
Count the highest number of days without “errors” 2

Top