Format Date for last month and year (1 Viewer)

[nirmal]

I am trying to get the last month and year by
=Format(Date(),"mmmm" & " " & "yyyy")
Here I am getting March 2023
Actually I am trying to get the sequential last mont with year like February 2023
Tried all, but in vain
Please guide

 

[arnelgp]

=Format(DateAdd("m",-1,Date()),"mmmm" & " " & "yyyy")

 

[nirmal]

Thank you Sir
It worked as expected.
Thank Again

 

[arnelgp]

the format can be simplified:

=Format(DateAdd("m",-1,Date()),"mmmm yyyy")

 

[nirmal]

Sir this format also works
Thanks Sir

 

[Gasman]

I am trying to get the last month and year by
=Format(Date(),"mmmm" & " " & "yyyy")
Here I am getting March 2023
Actually I am trying to get the sequential last mont with year like February 2023
Tried all, but in vain
Please guide

Why would you think that Date() would give you the previous month?