A1=11/05/2009 Start Date
A2=36 No of Months
A3= 11/30/12 Answer
A1=11/13/2009 Start Date
A2=36 No of Months
A3= 12/31/12 Answer
I need to have a formula so that in cell A3 is calculated on the basis, if the A1 is equalto or less than 10 then the answer is rounded to the end of the same month after adding number of months. Now if A1 is greater than or equal to 11 then answer is calculated to the end of next month after adding the number of months from A2. Thanks for the help.
Try
=IF(DAY(A1)<=10,EOMONTH(A1,A2),EOMONTH(A1,A2+1))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
In A1 do mean day <= 10?
...Answered by ChemistB.
Hi, welcome to the forum
Based on your sample data, put his in A3,...
=EOMONTH(EDATE(A1,A2),IF(DAY(A1)<11,0,1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Nice 1 ChemistB
Can be shortened to...
=EOMONTH(A1,A2+IF(DAY(A1)<=10,0,1))
Yeah, I think too linearly sometimes. Nice improvement, Ford
....Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks