Hello,

I am trying to populate my variable called PeriodDate with an End Of Month formula through VBA.
What I typed is below:

PeriodDate = EOMonth(....)

what happens after it adjusts is:

PeriodDate = EoMonth(....)

Could somebody please explain what I'm doing wrong?

Thanks