Trying to add a day to a last date of a month date ....

Copper Contributor

excel-formula-help.png

 

The image shows my formulas and their corresponding reference cells. As you can see, Friday, July 1st as a filename shows up as June 1 instead of July 1. I have tried multiple combinations (based off Google searches!) and can't seem to get it to work. 

 

Any help is sincerely appreciated! :grinning_face:

 

1 Reply
Have you ever tried Eomonth function?
That function find the end of month with months offset forward or backwards.
=Eomonth("5 Jun 2022",-1)= 31 May 2022
=Eomonth("5 Jun 2022",0)= 30 Jun 2022
=Eomonth("5 Jun 2022",1)= 31 Jul 2022

=Eomonth("5 Jun 2022",-1)+1= 1 Jun 2022
=Eomonth("5 Jun 2022",0)+1= 1 July 2022
=Eomonth("5 Jun 2022",1)= 1 Aug 2022