I have a calculated column which should return DepA, DepB or DepC according to the multiple IF statement which I cannot work out correctly!!!
I have a DateRequest which is entered by the user. I then have a ExpireDate which is a calculated column with the following formula
=IF(DAY(Created)<11,DATE(YEAR(Created),MONTH(Created)+1,0),DATE(YEAR(Created),MONTH(Created)+2,0))
What I need is: DateRequest is within the next 7 days should return DepA in the Department column (DateRequest = 08/02/21 today is 06/02/21 Department = A) If
If Date request is over the next 7 days but within ExpireDate should return DepB in the Department column (DateRequest 17/02/21 today is 06/02/21 ExpireDate 28/02/21 Department = B) If
If DateRequest is after ExpireDate should return DepC (DateRequest 05/03/21 today is 06/02/21 ExpireDate 28/02/21 Department = C)
I have tried the below two formulas unsuccessfully:
=IF((TODAY()+7>DateRequest, “DepA”), (IF(DateRequest)=<Expire),"DepB", “DepC”)
=IF(TODAY()+7>DateRequest, “DepA”), (IF(DateRequest)=<Expire),"DepB"), (IF(DateRequest)>Expire),"DepC")
What formula should I use, or is it even possible to incorporate ExpireDate formula in a single statement?