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

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

If A1 contains a date, then you can use:
=day(a1)
=month(a1)
=year(a1)

in separate cells or even in a formula.

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

--

Dave Peterson

hi,
i posted a reply to your question yesterday with a request to post back if i
got confused and the reply was not what you needed.
now you are posting again, the same question almost verbatim.
what was wrong with my reply.

regards
FSt1

"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

ohi
correction..repost to make more sense.
posted a reply to your question yesterday with a request to post back if i
got confused IF the reply was not what you needed.
now you are posting again, the same question almost verbatim.
what was wrong with my reply.

i would fire my post proof reader but unfortunely, i am he. sigh.

regards
FSt1

"FSt1" wrote:

hi,
i posted a reply to your question yesterday with a request to post back if i
got confused and the reply was not what you needed.
now you are posting again, the same question almost verbatim.
what was wrong with my reply.

regards
FSt1

"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

somehow I missed your reply. Am now trying to fully understand how to do
this. I am new to this problem so am a bit baffled.
Thanks for replying and sorry for the mixup


"FSt1" wrote:

hi,
i posted a reply to your question yesterday with a request to post back if i
got confused and the reply was not what you needed.
now you are posting again, the same question almost verbatim.
what was wrong with my reply.

regards
FSt1

"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

Novice as I am this issue has me stumped. Hope I can clarify better. I use
=Today()
in K3 then I try want to use the date only to create an entry to another
cell. (K3) is formatted to show 2/19/09. Want the month and year excluded.
Have looked at =day(K3) no luck if((K3=day19),123). End result is to have a
data entry on date specfic of every month.
Thanks for support one of my limited experience needs all I can get
Thanks Again


"FSt1" wrote:

ohi
correction..repost to make more sense.
posted a reply to your question yesterday with a request to post back if i
got confused IF the reply was not what you needed.
now you are posting again, the same question almost verbatim.
what was wrong with my reply.

i would fire my post proof reader but unfortunely, i am he. sigh.

regards
FSt1

"FSt1" wrote:

hi,
i posted a reply to your question yesterday with a request to post back if i
got confused and the reply was not what you needed.
now you are posting again, the same question almost verbatim.
what was wrong with my reply.

regards
FSt1

"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