how to calculate date ini and date fin based on a date

[jamiguel77]

Hi i have in A1="2019/12/13" the spected result on B1="2019/11/01" and in C1="2019/11/30"

B1=Date Intial (A1) subtract 1 month,
C1=Date End (A1) subtract 1 month,

Thanks
Any Help

 

[Coyotex3]

Maybe you can use these 2 formulas:

in cell B1

=EOMONTH(A1,-2)+1

in cell C1

=EOMONTH(A1,-1)

 

[jamiguel77]

Worked, Much Thanks

 

[Coyotex3]

Happy to help!