Custom Date Format
 

Using Excel 2003. (Australian Date Format).

In Cell B3, I want to type the month and year, eg: April 2008.
In Cell E33, I want to put =B3 so that the result appears as the last day of
the month, eg: 30/04/2008.

In Cell B3, I put a Custom Date Format of mmmm yyyy.
How do I get E33 to return me the last day of the month entered?

Lindy

Custom Date Format
 

Enter the following formula in E33 and format accordingly:
=EOMONTH(B3,0)


"Lindy" wrote in message
...
Using Excel 2003. (Australian Date Format).

In Cell B3, I want to type the month and year, eg: April 2008.
In Cell E33, I want to put =B3 so that the result appears as the last day
of
the month, eg: 30/04/2008.

In Cell B3, I put a Custom Date Format of mmmm yyyy.
How do I get E33 to return me the last day of the month entered?

Lindy

Custom Date Format
 

Thanks so much. Exactly what I wanted. I appreciate your help and your quick
response.
Lindy


"Castell" wrote:

Enter the following formula in E33 and format accordingly:
=EOMONTH(B3,0)


"Lindy" wrote in message
...
Using Excel 2003. (Australian Date Format).

In Cell B3, I want to type the month and year, eg: April 2008.
In Cell E33, I want to put =B3 so that the result appears as the last day
of
the month, eg: 30/04/2008.

In Cell B3, I put a Custom Date Format of mmmm yyyy.
How do I get E33 to return me the last day of the month entered?

Lindy

Custom Date Format
 

=DATE(YEAR(B3),MONTH(B3)+1,0)
Format to suit.
--
David Biddulph

"Lindy" wrote in message
...
Using Excel 2003. (Australian Date Format).

In Cell B3, I want to type the month and year, eg: April 2008.
In Cell E33, I want to put =B3 so that the result appears as the last day
of
the month, eg: 30/04/2008.

In Cell B3, I put a Custom Date Format of mmmm yyyy.
How do I get E33 to return me the last day of the month entered?

Lindy

Custom Date Format
 

Glad to help. Thanks for your feedback.


"Lindy" wrote in message
...
Thanks so much. Exactly what I wanted. I appreciate your help and your
quick
response.
Lindy


"Castell" wrote:

Enter the following formula in E33 and format accordingly:
=EOMONTH(B3,0)


"Lindy" wrote in message
...
Using Excel 2003. (Australian Date Format).

In Cell B3, I want to type the month and year, eg: April 2008.
In Cell E33, I want to put =B3 so that the result appears as the last
day
of
the month, eg: 30/04/2008.

In Cell B3, I put a Custom Date Format of mmmm yyyy.
How do I get E33 to return me the last day of the month entered?

Lindy

Custom Date Format
 

Thank you. I experimented with your formula as well and it gives me the right
result too. The helpful people in this forum are wonderful.
Lindy


"David Biddulph" wrote:

=DATE(YEAR(B3),MONTH(B3)+1,0)
Format to suit.
--
David Biddulph

"Lindy" wrote in message
...
Using Excel 2003. (Australian Date Format).

In Cell B3, I want to type the month and year, eg: April 2008.
In Cell E33, I want to put =B3 so that the result appears as the last day
of
the month, eg: 30/04/2008.

In Cell B3, I put a Custom Date Format of mmmm yyyy.
How do I get E33 to return me the last day of the month entered?

Lindy