Convert edate formual to VBA

[smithke29]

I have the following formula in a cell: =EDATE(B5,ROUNDUP((((YEAR(C7)-YEAR(B5))*12+(MONTH(C7)-MONTH(B5)+1))/2),0))))

I want to convert this to VBA but I can't figure out exactly how to write this. Any assistance that can be provided is appreciated. I'm using MS Excel 2010

 

[Rick Rothstein]

I have the following formula in a cell: =EDATE(B5,ROUNDUP((((YEAR(C7)-YEAR(B5))*12+(MONTH(C7)-MONTH(B5)+1))/2),0))))

I want to convert this to VBA but I can't figure out exactly how to write this. Any assistance that can be provided is appreciated. I'm using MS Excel 2010

If this is a single formula reference, you can just evaluate the formula directly within VBA. Here I am assuming you are assigning the calculated value to a variable named Diff...

[table="width: 500"]
[tr]
	[td]Diff = Evaluate("EDATE(B5,ROUNDUP((((YEAR(C7)-YEAR(B5))*12+(MONTH(C7)-MONTH(B5)+1))/2),0))")[/td]
[/tr]
[/table]

If it is not a single cell reference, then you need to tell us about your layout and where the result is to go to.

 

[smithke29]

Thanks... This is what I was looking for.