This is very useful in creating an invoice, in which case, you usually
create an invoice for the last month.

So, given today Arpil 1, 2009, how to get March 1, 2009 and March 31,
2009

Suppose I have 04/01/2009 in A3

I have been able to find the first date of March through this in for
example F8.

= TEXT(DATE(YEAR(A3), MONTH(A3)-1, 1), "mm/dd/yyyy")

Now, how do I find the last date of the previous month?

Thank you.

How about the 1st day of this month minus ONE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Author" wrote in message
...
This is very useful in creating an invoice, in which case, you usually
create an invoice for the last month.

So, given today Arpil 1, 2009, how to get March 1, 2009 and March 31,
2009

Suppose I have 04/01/2009 in A3

I have been able to find the first date of March through this in for
example F8.

= TEXT(DATE(YEAR(A3), MONTH(A3)-1, 1), "mm/dd/yyyy")

Now, how do I find the last date of the previous month?

Thank you.

On Apr 1, 5:25*pm, "Don Guillett" wrote:
How about the 1st day of this month minus ONE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Author" wrote in message


Sounds cool, but how? I am not an Excel person.

=DATE(YEAR(A3),MONTH(A3),0)
for last day of pervious month

and
=DATE(YEAR(A3),MONTH(A3)-1,1)

for the first day of previous month...

If you want in text format then put TEXT around it with desired format...

--

-Sheeloo
-------------------------------------
Pl. click ''Yes'' if this was helpful...



"Author" wrote:

This is very useful in creating an invoice, in which case, you usually
create an invoice for the last month.

So, given today Arpil 1, 2009, how to get March 1, 2009 and March 31,
2009

Suppose I have 04/01/2009 in A3

I have been able to find the first date of March through this in for
example F8.

= TEXT(DATE(YEAR(A3), MONTH(A3)-1, 1), "mm/dd/yyyy")

Now, how do I find the last date of the previous month?

Thank you.

For the last day of the previous month:

=A3-DAY(A3)

For the first day of the previous month:

=DATE(YEAR(A3),MONTH(A3)-1,1)

--
Biff
Microsoft Excel MVP


"Author" wrote in message
...
This is very useful in creating an invoice, in which case, you usually
create an invoice for the last month.

So, given today Arpil 1, 2009, how to get March 1, 2009 and March 31,
2009

Suppose I have 04/01/2009 in A3

I have been able to find the first date of March through this in for
example F8.

= TEXT(DATE(YEAR(A3), MONTH(A3)-1, 1), "mm/dd/yyyy")

Now, how do I find the last date of the previous month?

Thank you.

On Wed, 1 Apr 2009 14:14:37 -0700 (PDT), Author wrote:

This is very useful in creating an invoice, in which case, you usually
create an invoice for the last month.

So, given today Arpil 1, 2009, how to get March 1, 2009 and March 31,
2009

Suppose I have 04/01/2009 in A3

I have been able to find the first date of March through this in for
example F8.

= TEXT(DATE(YEAR(A3), MONTH(A3)-1, 1), "mm/dd/yyyy")

Now, how do I find the last date of the previous month?

Thank you.

Some date in A1.

First date of previous month:

=A1-DAY(A1)-DAY(A1-DAY(A1))+1

or

=DATE(YEAR(A1), MONTH(A1)-1,1)

Last Date of previous month:

=A1-DAY(A1)

--ron