By craig.cude ·
I'm trying to take the left two characters from a date (10/1/99, for example) and put them in a separate column so it would read "10". However, EXCEL is reading it as a Julian number (36434) and it is returning "36" to the column instead. Does anyone know how fix this so it just reads the "10"?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Assuming that your date is US

by neilb@uk In reply to Duplicate

You'd use =MONTH(cell.ref)

If you used proper dates, like us, it would be =DAY(cell.ref)

Collapse -

Hey! Why ask this Mickey Mouse question twice?

by neilb@uk In reply to Duplicate

I scroll down a bit and find it asked and answered. I'm not best pleased!

Collapse -

I apologize for the repost

by craig.cude In reply to Duplicate

I'm new at this site and this yesterday was my first question. This morning I didn't see my first question posted (or any of the replies so I reposted today. I apologize for the trouble.

Collapse -

A thumb buys you forgiveness

by neilb@uk In reply to I apologize for the repos ...

I'm so easily bought!


Related Discussions

Related Forums