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

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

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

=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

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

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