Patricia Timm
asked on
adding a formula to check dates
How would I write a formula to check a cell and if it falls in between and including 10/1/18 and 9/30/20 then write lapsed in the corresponding cell next to it
ie
date new cell
10/1/18 lapsed
10/15/18 lapsed
ie
date new cell
10/1/18 lapsed
10/15/18 lapsed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.