Let's say the date is in A1. Try this. It's fairly obvious, once you know
what to use.

=MONTH(A1)
=YEAR(A1)
=DAY(A1)

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Curt" wrote:

is there a way to have excel display the month-day-year in seperate cells. I
need to use the day for reference. If day =x then this. I want excel to
continue to update date as normal. Then I can use the day number to get what
I want. This will continue monthly and yearly if I can.
Thanks