Software

Ask something
Question Locked

Duplicate

0 helpful
5 replies

by craig.cude

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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"?

Thanks!

5 replies

by Member 25348569

You'd use =MONTH(cell.ref)

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

:D

by Member 25348569

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

:(

by craig.cude

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.

This discussion is closed to new replies.