Date

  • Thread starter Thread starter robzrob
  • Start date Start date
R

robzrob

Hello All

New to this, so this question may have been answered before - don't
know.

I want to be able to add one calendar month and then 2 days to any
date. Any ideas?

Thanks

R
 
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)+2)
[subject to the usual question as to what you mean by adding a calendar
month to a date like 31st January].
 
Hello All

New to this, so this question may have been answered before - don't
know.

I want to be able to add one calendar month and then 2 days to any
date. Any ideas?

Thanks

R
Click to expand...

Thanks all. This raises another question now! I was assuming that
adding a calendar month meant any of, for example: 28/01/07, 29/01/07,
30/01/07, 31/01/07 would become 28/02/07 and, for example: 31/08/07
would become 30/09/07, etc, in which case your formula won't work. So
does adding a calendar month mean adding the number of days in the
month the date in question is actually IN - in which case your formula
WILL work? Hmm. (Sorry - the CAPS mean emphasis - not shouting -
don't know how to italicise here.)
 
So if adding 1 month should never take you beyond the end of the next month try

=EDATE(A1,1)+2

EDATE is part of Analysis ToolPak add-in. To get the same result without the
add-in try

=MIN(DATE(YEAR(A1),MONTH(A1)+1+{1,0},DAY(A1)*{0,1}))+2
 
So if adding 1 month should never take you beyond the end of the next month try

=EDATE(A1,1)+2

EDATE is part of Analysis ToolPak add-in. To get the same result without the
add-in try

=MIN(DATE(YEAR(A1),MONTH(A1)+1+{1,0},DAY(A1)*{0,1}))+2






- Show quoted text -
Click to expand...

Thanks DLL - seems to be working - now I can relax!
 
Back
Top