Defeating dates

[gaftalik]

Hello ,

Is it possible to use the EOMONTH function in this formula which adds months to a date in order to shorten the whole formula

It should come somewhere after the Min(day(I7....

Many thanks to the one who untie this !

Book1
	H	I	J	K	L
5
6
7		31.01.2004	29.02.2004
8
9
10
Sheet1

 

[jcvoth]

How about the following:

=EOMONTH(i7+1,0)

-Jarrod

 

[Aaron Blood]

If you'd like to avoid using the analysis toolpack EOMONTH function, here's another way to think about it:

=DATE(YEAR(I7),MONTH(I7)+2,1)-1

 

[Andrew Poulsom]

Or:

=DATE(YEAR(I7),MONTH(I7)+2,0)

 

[gaftalik]

You know sometimes it is so obvious that you are blacked out !
i was trying to eomonth(month(i7)+1;0)

This wall is so soft for me



many thanks Jarrod !

 

[gaftalik]

All of them are great thanks to All for your help

By the way glad to hear from you Mr Aaron , i am one of your fans who downloaded many of your sheets !which still a mystery for me

Thousands of thanks !

 

[Aaron Blood]

Or:

=DATE(YEAR(I7),MONTH(I7)+2,0)

That's interesting! Day zero...

So you could even drop the zero completly then:
=DATE(YEAR(I7),MONTH(I7)+2,)

Interesting.

Makes you wonder why they even bothered creating an EOMONTH function to begin with. If they had that much free time on their hands, they could've better spent it creating the reciprical PV function for FVSCHEDULE.