Date manipulation

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

Try

=EOMONTH(A1,-2)+1

Originally Posted by KOKOSEK

Try:

Formula:

Please Login or Register  to view this content.

with you date in A1.

KOKOSEK - Thank you!

Originally Posted by KOKOSEK

Try:

Formula:

Please Login or Register  to view this content.

with you date in A1.

Is this function available in VBA?

Originally Posted by Roel Jongman

in vba use

Please Login or Register  to view this content.

Roel Jongman - That works! Thank you.