I am trying to make a formula to take a column with dates and if they are between 11/30/16 to 12/08/16 then put statement "MONTH END".
Description Date Formula
Accounts Payable Accrual 11/30/2016 MONTHEND
Accounts Payable Accrual 11/30/2016 MONTHEND
Accounts Payable Accrual 11/30/2016 MONTHEND
Accounts Payable Accrual 12/11/2016 NA
Accounts Payable Accrual 12/12/2016 NA
Accounts Payable Accrual 12/13/2016 NA
Accounts Payable Accrual 12/06/2016 MONTHEND
Description Date Formula
Accounts Payable Accrual 11/30/2016 MONTHEND
Accounts Payable Accrual 11/30/2016 MONTHEND
Accounts Payable Accrual 11/30/2016 MONTHEND
Accounts Payable Accrual 12/11/2016 NA
Accounts Payable Accrual 12/12/2016 NA
Accounts Payable Accrual 12/13/2016 NA
Accounts Payable Accrual 12/06/2016 MONTHEND