I upload information for the previous month end. I currently use only the
Month and Year, so =TODAY()-10 works. However, I would like to insert the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?

One way to get the end of Sep
=DATE(2006,10,1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I upload information for the previous month end. I currently use only the
Month and Year, so =TODAY()-10 works. However, I would like to insert the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?

I think I need the formula to consider the current month and input the
previous month end. Example: Today is September 8, 2006, and I need the
formula to input August 31, 2006

"Don Guillett" wrote:

One way to get the end of Sep
=DATE(2006,10,1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I upload information for the previous month end. I currently use only the
Month and Year, so =TODAY()-10 works. However, I would like to insert the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?

=date(year(today()),month(today()),1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I think I need the formula to consider the current month and input the
previous month end. Example: Today is September 8, 2006, and I need the
formula to input August 31, 2006

"Don Guillett" wrote:

One way to get the end of Sep
=DATE(2006,10,1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I upload information for the previous month end. I currently use only
the
Month and Year, so =TODAY()-10 works. However, I would like to insert
the
month, day, and year (Ex: August 31, 2006). Is there a way to do
this?

=TODAY()-DAY(TODAY())

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tristan" wrote in message
...
I think I need the formula to consider the current month and input the
previous month end. Example: Today is September 8, 2006, and I need the
formula to input August 31, 2006

"Don Guillett" wrote:

One way to get the end of Sep
=DATE(2006,10,1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I upload information for the previous month end. I currently use only
the
Month and Year, so =TODAY()-10 works. However, I would like to insert
the
month, day, and year (Ex: August 31, 2006). Is there a way to do
this?

Tristan

Perhaps this formula?

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

Returns August 31, 2006


Gord Dibben MS Excel MVP


On Fri, 8 Sep 2006 14:12:04 -0700, Tristan
wrote:

I think I need the formula to consider the current month and input the
previous month end. Example: Today is September 8, 2006, and I need the
formula to input August 31, 2006

"Don Guillett" wrote:

One way to get the end of Sep
=DATE(2006,10,1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I upload information for the previous month end. I currently use only the
Month and Year, so =TODAY()-10 works. However, I would like to insert the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?

Solution received in multiple posts. Thanks to all for the assistance.

"Tristan" wrote:

I upload information for the previous month end. I currently use only the
Month and Year, so =TODAY()-10 works. However, I would like to insert the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?

Bob's the best

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
Solution received in multiple posts. Thanks to all for the assistance.

"Tristan" wrote:

I upload information for the previous month end. I currently use only
the
Month and Year, so =TODAY()-10 works. However, I would like to insert
the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?