Oh, this looks promising. Sorry for my slowness, I'm novice and understanding unfamiliar code takes me a while.
We can always rely on, that the requested month will be only the one defined by cell "D3" (I'm not planning this function to sum values from more than single month), so if I'm not mistaken I could ommit this entire code block ? :
And directly use my original variables, when I'll declare them as Date types? something like this ? Edit: Actually I don't need to change my original variable types, I'll leave them as Integers.
Then I'll use the dhLastDayInMonth variable in .Find function ?
Bookmarks