Date function

[GიორGი]

Is in excel such function:
when i write number in B column, In column A its preposition elong must write date..?
p.s. sorry for my bad English...

[NBVC]

Maybe if you give an example of what you want to do, we can understand better.

[contaminated]

Гомар джоба гого / биджо

Я ничего не понял ничего из того что ты сказал, понял только то, что ты хочешь функцию даты...
Скажи на русском, объясним что к чему!!!!!!

[DonkeyOte]

If you want to move this thread to the Non-English Forum let us know...

[contaminated]

I think that's would be better

[ylind]

A B C D E F G H

Kingston Elliott, Judith Anne 38-01-23 ?? ?? ??


is there a simple way break down the date in Col E into separate columns ie: YEAR, MONTH and DAY

Thx
y.L

[DonkeyOte]

ylind, Welcome to the Board, however, please note:

Your post does not comply with Rule 2 of our Forum RULES.
Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

[Raiby]

A B C D E F G H

Kingston Elliott, Judith Anne 38-01-23 ?? ?? ??


is there a simple way break down the date in Col E into separate columns ie: YEAR, MONTH and DAY

Thx
y.L

Hi, you didn't indicate your excel version.
With Excel 07

First
Ctrl+h
Find: -
Replace by space

Secondly
Table Design tab, Tools group Convert