Code:
=AND(INDIRECT("V"&ROW())>=TODAY(),INDIRECT("V"&ROW())<=(TODAY()+INDIRECT("U"&ROW())))
For example, the CF should be applied if today is the 14th or 15th, V=15th and U=1.
Last edited:
=AND(INDIRECT("V"&ROW())>=TODAY(),INDIRECT("V"&ROW())<=(TODAY()+INDIRECT("U"&ROW())))