Need some help please...

[Zacequinox]

Hi all,
I am after a formula that adds months to a date then returns text:
Ive got a 12 month cycle:
If there is more than 9 months remaining then, blank
If there is between 9 months and 1 month remaining then, 3 months
If there is less than 1 month then, 1 month
If it is today then, Due Now
If is older than today then, overdue
Any help on this would be really appreciated.

01-Nov-21
01-Jan-21	3 months
01-Jan-21	3 months
01-Dec-21	1 month
01-Nov-20	Due Now
01-Oct-20	Overdue

 

[JGordon11]

Book5
	A	B
1	today	11/13/2021
2
3	Due	Spec
4	9/9/2022
5	1/27/2022	3 Months
6	12/3/2021	1 Month
7	11/13/2021	Due Now
8	11/3/2021	Overdue
Sheet1

Cell Formulas
Range	Formula
B4:B8	B4	=LOOKUP(A4-TODAY(),{-9999,0,1,31,270},{"Overdue","Due Now","1 Month","3 Months",""})

 

[Peter_SSs]

Welcome to the MrExcel board!

To be more accurate with the months I think you will need a longer formula. See if this does what you want.

21 11 14.xlsm
	A	B
1	Today	14/11/2021
2
3	Date	Status
4	14/11/2021	Due Now
5	14/10/2022
6	13/08/2022	3 months
7	28/11/2021	1month
8	14/08/2021	Overdue
9	14/12/2021	3 months
Due Status

Cell Formulas
Range	Formula
B1	B1	=TODAY()
B4:B9	B4	=IF(EDATE(B$1,9)<=A4,"",IF(EDATE(B$1,1)<=A4,"3 months",IF(B$1>A4,"Overdue",IF(B$1=A4,"Due Now","1month"))))