Display month based on calculations

[Hawkeyes26]

I need a formula that will display “if a selected date +21 days is at least 30 days from the 1st of the next month, then display the next month. If less than 30 days from the first of the next month, then display the next month + 1 month.”

For example, if a selected date is 9/11, then 21 days from that date would be 10/1. Since this is 30 days from the next month, 11/1, then I need to display 11/1.

If a selected date is 9/17, then 21 days from that date would be 10/7. Since 10/7 is less than 30 days from the next month, 11/1, I need to display 12/1:

 

[awoohaw]

try this:

Mr excel questions 58.xlsm
	A	B	C	D	E	F
1
2
3		Selected Date	21 Days Date	Days to Next Month	Desired Result	FORMULA
4		2023-09-11	2023-10-02	30	2023-11-01	2023-11-01
5		2023-09-17	2023-10-08	24	2023-12-01	2023-12-01
Hawkeyes26

Cell Formulas
Range	Formula
C4:C5	C4	=B4+21
D4:D5	D4	=EOMONTH(C4,0)+1-C4
F4:F5	F4	=IF(EOMONTH(B4+21,0)+1-(B4+21)<30,EOMONTH(B4+21,1)+1,EOMONTH(B4+21,0)+1)