# Defeating dates

#### gaftalik

##### Well-known Member
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
HIJKL
5
6
731.01.200429.02.2004
8
9
10
Sheet1

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

=EOMONTH(i7+1,0)

-Jarrod

#### Aaron Blood

##### Active Member
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

##### MrExcel MVP
Or:

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

#### gaftalik

##### Well-known Member
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

##### Well-known Member
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

##### Active Member
Andrew Poulsom said:
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.

Replies
5
Views
197
Replies
4
Views
173
Replies
3
Views
1K
Replies
2
Views
260
Replies
3
Views
561

1,187,173
Messages
5,962,033
Members
438,576
Latest member
Cstewart29

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back