Date Formulas & format
 

Dear all

I have in cell A1 the formula =NOW(), in order to have the currnet date.
I want ot split in A2, A3, and A4 the date, month and year resprectivly, and
in format of date, month & year
eg: A1- 02/08/2007
i want in A2 02, A3-August, A4-2007,

What can i do and what type of format should i have in A3 in order to see
August instead of 08.

Thanks in advance
Manos

Date Formulas & format
 

On 2 Aug, 10:02, Manos wrote:
Dear all

I have in cell A1 the formula =NOW(), in order to have the currnet date.
I want ot split in A2, A3, and A4 the date, month and year resprectivly, and
in format of date, month & year
eg: A1- 02/08/2007
i want in A2 02, A3-August, A4-2007,

What can i do and what type of format should i have in A3 in order to see
August instead of 08.

Thanks in advance
Manos

a2 should be

=day(a1)

cell formatted to 2 digits

A3 becomes
=text(a1,"mmmm")

A4 is

=year(a1)

Date Formulas & format
 

Hi,

In A2, A3 and A4 enter the formula =A1

Then use a custom format on each cell

a2= dd
A3 = mmmm
A4 =yyyy

Mike

"Manos" wrote:

Dear all

I have in cell A1 the formula =NOW(), in order to have the currnet date.
I want ot split in A2, A3, and A4 the date, month and year resprectivly, and
in format of date, month & year
eg: A1- 02/08/2007
i want in A2 02, A3-August, A4-2007,

What can i do and what type of format should i have in A3 in order to see
August instead of 08.

Thanks in advance
Manos

Date Formulas & format
 

thank you

" wrote:

On 2 Aug, 10:02, Manos wrote:
Dear all

I have in cell A1 the formula =NOW(), in order to have the currnet date.
I want ot split in A2, A3, and A4 the date, month and year resprectivly, and
in format of date, month & year
eg: A1- 02/08/2007
i want in A2 02, A3-August, A4-2007,

What can i do and what type of format should i have in A3 in order to see
August instead of 08.

Thanks in advance
Manos

a2 should be

=day(a1)

cell formatted to 2 digits

A3 becomes
=text(a1,"mmmm")

A4 is

=year(a1)