Hi, i have a formula that works great to add 24 months to the date from date column Date Consent Received. I can’t seem to get my IF formula correct so that if the Date Consent Received is empty it will display a message like No Consent Date Set.
This is my working formula:
FORMAT_DATE(IF(MONTH(DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24,1)) = MONTH(DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24,DAY({Date Consent Received}))),DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24,DAY({Date Consent Received})),SUBTRACT_DAYS(DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24+1,1),1)), “D MMM, YYYY”)
This is what i’m trying with my IF version:
IF({Date Consent Received},“No Date”,FORMAT_DATE(IF(MONTH(DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24,1)) = MONTH(DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24,DAY({Date Consent Received}))),DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24,DAY({Date Consent Received})),SUBTRACT_DAYS(DATE(YEAR({Date Consent Received}),MONTH({Date Consent Received})+24+1,1),1)), “D MMM, YYYY”),0)
Any help greatly appreciated!