PC Review


Reply
Thread Tools Rate Thread

Date arithmetic: adding 1 month to prior end of month date

 
 
=?Utf-8?B?bWFueG1hbg==?=
Guest
Posts: n/a
 
      14th Jul 2006
I'm using the =DATE(YEAR(B32),MONTH(B32)+1,DAY(B32)) where B32 is the prior
date. This works fine when the prior month's day is not the last day of the
month. If it is the last day, the results are a little goofy. For example,
adding one month to 6/30/06 produces 7/30/06 instead of 7/31/06. Adding one
month to 1/31/06produces 3/3/06 instead of 2/28/06.

Is there a way to add whole months to prior months when the prior month's
day is the last day of the month?
 
Reply With Quote
 
 
 
 
SteveG
Guest
Posts: n/a
 
      14th Jul 2006

manxman,

You could use,

=EOMONTH(A1,1)

Where A1 = your start date. You need the Analysis ToolPak installed t
use the EOMONTH function. Tools, AddIns, select Analysis ToolPak an
click OK.

HTH

Stev

--
Steve
-----------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...nfo&userid=757
View this thread: http://www.excelforum.com/showthread.php?threadid=56157

 
Reply With Quote
 
=?Utf-8?B?bWFueG1hbg==?=
Guest
Posts: n/a
 
      14th Jul 2006
That does it. Thanks very much.

"SteveG" wrote:

>
> manxman,
>
> You could use,
>
> =EOMONTH(A1,1)
>
> Where A1 = your start date. You need the Analysis ToolPak installed to
> use the EOMONTH function. Tools, AddIns, select Analysis ToolPak and
> click OK.
>
> HTH
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=561577
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weekending Date w/Less Than 3 days Assoc. with Prior Month MoneyMan Microsoft Excel Worksheet Functions 7 14th Sep 2009 06:45 PM
Dates - Need to display date one month prior to user-entered date brettopp Microsoft Excel Worksheet Functions 13 3rd Dec 2007 05:58 PM
display prior month's date =?Utf-8?B?TWFyeVN1ZQ==?= Microsoft Access Reports 2 17th Dec 2006 11:25 PM
printing Little Current month and Little Next month on Banner when it should little PRIOR month and little Next month. jake_allen10@hotmail.com Microsoft Outlook 0 3rd Nov 2006 07:30 PM
Converting Month/Date/Year data & sorting by month/date only =?Utf-8?B?Uy4gV2FzaGluZ3Rvbg==?= Microsoft Excel Worksheet Functions 4 26th Apr 2004 05:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:11 AM.