Using a range of dates for placing one date in a certain cell

[Jpburger]

Using a range of dates to place one date in a cell
Happy Holidays Y'all! I am working on an spreadsheet using MS Excel 2007. One thing that I want to accomplish is the following:
Use a range of dates to specify an exact date, of which I want the computer to automatically fill in for me in one field based on a date that I enter in a different field.

For example, if I type in 11/16/2012 in cell A1, then I want cell A2 to show this date 11/30/2012. Why? Because I want the computer to recognize that if any of these dates 11/16/2012 through 11/30/2012 are typed into cell A1, then A2 needs to show 11/30/2012. If in cell A1, I type 12/02/2012, then I want cell A2 to show 12/15/2012 because dates 12/01/2012 through 12/15/2012 in A1 need to show 12/15/2012 in A2.

Thanks in advance for your help. Also, this is my first time using Excel Forum.

[Moo the Dog]

I am sure there is an easier way to do this, but for fun:

=IF(DAY(A1)>15,EOMONTH(A1,0),DATE(YEAR(A1),MONTH(A1),15))

- Moo

[Legend Rubber]

Book1.xlsx
even harder than that...

[Moo the Dog]

even harder than that...

@Legend - LOL, that made me chuckle. You are quite bored, aren't you?

-Moo

[Legend Rubber]

@Moo
No, just not that great with formulas...
Mainly i use IF AND OR and VBA... but VERY beginner.... but learner...

[Legend Rubber]

@Moo
How do you get 850 posts in the same time as i have got only 200 ??? No Fair...
You must have too much time... or else your boses dont keep track of you good enough....

[Moo the Dog]

@Moo
How do you get 850 posts in the same time as i have got only 200 ??? No Fair...
You must have too much time... or else your boses dont keep track of you good enough....

@Legend - LOL... I must have ExcelForum separation anxiety issues or something.
I definitely could have had more posts by now if I knew even the slightest bit of VBA.
Just like you, I am a work in progress - always learning stuff on here.

Also, just so you know, I wasn't poking fun at your solution above, it was the 'even harder than that' comment that I found amusing. All solutions can provide insight into different ways of attacking a problem.

- Moo

[Legend Rubber]

@Moo,
Hey, i didnt take any offense at all...
I am very impressed with your solution...
In fact, i am adding to your rep...

[Moo the Dog]

@Legend - Thanks, bud. Much appreciated. =)

- Moo

[Legend Rubber]

@ Moo
No porblem, hit me back some time...