Hi Everyone!
I'm completely self-taught in excel and can normally maneuver my way around VBA pretty easily (thanks to this board!), however I can't seem to figure this issue out.
I have the following formula that I want to enter into cell M2:
"currentmonth" is a value that I want to get from an InputBox. (This is because i'm not always going to be analyzing the current month that I'm in). I basically want the value of the date that I enter into the InputBox to be represented in the formula. I know I'm way off on this because I keep getting a #NAME error and when I click M2 it says currentmonth where I would like for it to say 41455 (June 30). I'm essentially creating a template that will have a different month used each time so that is why the inputbox is necessary.
Here is the code I'm using:
Thank you all!
Bookmarks