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" <(E-Mail Removed)> wrote in message
news:2CF6FE98-E658-4C47-9023-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:2CF6FE98-E658-4C47-9023-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:2CF6FE98-E658-4C47-9023-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:03AAC0CD-D5DD-4B40-8519-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:2CF6FE98-E658-4C47-9023-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
> news:2CF6FE98-E658-4C47-9023-(E-Mail Removed)...
> > 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
> >
> >
>
>
>