RE DateFunction

[SusanM]

Hello Again,

Sorry I did use thread discussion. Dont always get an
answer.
I just sent a question about date function. Norman was a
big help, but the 6 months part is not working properly.
Error message to many arguments. Can someone take a look
please?
Appreciate your help.

SusanM

 

[Frank Kabel]

Hi Susan
what formula did you exactly use (maybe there was a problem with
linebreaks). The following should do (A1 stores your base date):
=DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR(A1),MONTH(A1)+6+1,
0))))

all in one line!

 

[SusanM]

Thank Frank and Norman!
I can sleep tonight

-----Original Message-----
Hi Susan
what formula did you exactly use (maybe there was a problem with
linebreaks). The following should do (A1 stores your base date):
=DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR (A1),MONTH(A1)+6+1,
0))))

all in one line!


--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Norman Harker]

Hi Frank and Susan!

That $A1 reference was given to allow the copying down of the formula so
that the same operation could be performed on all sorts of dates in column
A. I left the absolute reference on A so as to cover the possibility of
someone who might want to copy the formula across. If you don't do that, you
can get some strange results. In normal use where there is only 1 base date
we use $A$1 as that allows copying down and across.


--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.