Date formula: Month +3, Day -1

lhidden

Hello Team, I am trying to write a formula that takes an inputted date and outputs a M+3, D-1 formula. The very tricky part is input for 1st of month should then be M+2 / D is last day of the month

 

Examples:

 

1. Input 6/5 -> output 9/4  
2. Input 5/25, -> output 8/24 
3. Input 3/31 -> output 6/30    
4. Input 1/1 -> output 3/31     
5. Input 7/1 -> output 9/30      

 

Is this possible? 

lhidden

Could you please provide an example? I have never used DAYSINMONTH()

 

Thank you!