EVERY AUGUST MONTH IN COLUMN "A" CONVERT INTO TEXT IN COLUMN "C" AS "INC" AND ANY REMARK COLUMN "C" TEST AS "AAS" OR "SL" FROM MY EXCEL TABLE

[ravindra1962]

from the excel data
Every august month any year in column "A" shows in Remark column "C" as text "inc"
if any month remark column "c" as text "SL" or "AAS"
need formula plZ

From	to	Reamrk
01-07-2019	31-07-2019
01-08-2019	31-08-2019	INC
01-09-2019	30-09-2019
01-10-2019	31-10-2019
01-11-2019	30-11-2019
01-12-2019	31-12-2019
01-01-2020	31-01-2020
01-02-2020	29-02-2020
01-03-2020	31-03-2020
01-04-2020	30-04-2020
01-05-2020	31-05-2020
01-06-2020	30-06-2020
01-07-2020	31-07-2020
01-07-2020	15-07-2020	SL
01-08-2020	31-08-2020	INC
01-09-2020	30-09-2020
01-10-2020	31-10-2020
01-11-2020	30-11-2020	AAS
01-12-2020	31-12-2020

 

[bebo021999]

=IF(AND(MONTH(A2)=8,MONTH(B2)=8),"INC",IF(AND(MONTH(A2)=7,YEAR(A2)=2020, MONTH(B2)=7,YEAR(B2)=2020),"SL",IF(AND(MONTH(A2)=11,YEAR(A2)=2020, MONTH(B2)=11,YEAR(B2)=2020),"AAS",""))))

 

[ravindra1962]

SMALL ERROR IN : "SL"

From	to	REMARK
01-07-2019	31-07-2019
01-08-2019	31-08-2019	INC	INC
01-09-2019	30-09-2019
01-10-2019	31-10-2019
01-11-2019	30-11-2019
01-12-2019	31-12-2019
01-01-2020	31-01-2020
01-02-2020	29-02-2020
01-03-2020	31-03-2020
01-04-2020	30-04-2020
01-05-2020	31-05-2020
01-06-2020	30-06-2020
01-07-2020​	31-07-2020		SL	ERROR
01-07-2020	15-07-2020	SL	SL
01-08-2020	31-08-2020	INC	INC
01-09-2020	30-09-2020
01-10-2020	31-10-2020
01-11-2020	30-11-2020	AAS	AAS
01-12-2020	31-12-2020

 

[bebo021999]

"1-Jul-20 to 31-Jul-20" belongs to Jul-20 then it gave "SL". Why not?

 

[ravindra1962]

"1-Jul-20 to 31-Jul-20" belongs to the Jul-20 REGULAR SALARY. IT SHOWS BLANK
AND THEN "1-Jul-20 to 15-Jul-20" belongs to SUPPLEMENTARY LEAVE SALARY, IT (15 DAYS SALARY) WAS SANCTION IN THE MONTH OF JULY 20 SIR