date issue
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 |
date issue
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 |
date issue
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 |
date issue
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 |
date issue
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 |
date issue
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 |
date issue
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 |
All times are GMT +1. The time now is 10:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com