Date manipulation

[bvwalker1]

Is there a function that can help me do the following... Given a month/day/year return the first of the previous month. So, 1/22/2019 would become 12/1/2018

[Root_]

Try

=EOMONTH(A1,-2)+1

[KOKOSEK]

Try:

Please Login or Register  to view this content.

with you date in A1.

[bvwalker1]

Try:

Please Login or Register  to view this content.

with you date in A1.

KOKOSEK - Thank you!

[bvwalker1]

Try:

Please Login or Register  to view this content.

with you date in A1.

Is this function available in VBA?

[Roel Jongman]

in vba use

Please Login or Register  to view this content.

[bvwalker1]

in vba use

Please Login or Register  to view this content.

Roel Jongman - That works! Thank you.