compare two dates and check if the date exceeds another one for a month or not

[rockyhawkky]

Hi there, anybody can help me with the date comparison?
I just want to compare two dates then i wanna know if date in colum B exceeds date in colum A for a month and 3 months. if true just put a text on colum C.

material delivery.xlsx
	A	B	C
1	15/12/2022	15/01/2023	EXCEEDS FOR A MONTH
2	15/12/2022	15/03/2023	EXCEEDS FOR 3 MONTHS
Sheet1

Thank you,

 

[bebo021999]

Use this in C1:

=IFERROR(IF(DATEDIF(A1,B1,"m")=0,"","EXCEEDS FOR "&IF(DATEDIF(A1,B1,"m")=1,"A  MONTH",DATEDIF(A1,B1,"m") &" MONTHS")),"")

 

[rockyhawkky]

Use this in C1:

=IFERROR(IF(DATEDIF(A1,B1,"m")=0,"","EXCEEDS FOR "&IF(DATEDIF(A1,B1,"m")=1,"A  MONTH",DATEDIF(A1,B1,"m") &" MONTHS")),"")

@bebo021999 thank you very much. that's exactly what i meant.