I suggest you use TODAY() rather than NOW() if you are only interested
in the date and not the time.

Hope this helps.

Pete

On Aug 30, 6:02*pm, WAHEEB AKEEL
wrote:
MY FORMULA IS
=SUMIF(Y3:Y104,"=27-AUG",R3:R104)-(L106+L107)

HOW CAN I *USE UPDATABLE CRITERIA, INSTEAD THE ABOVE , FOR EXAMPLE C:I WHICH
IS =NOW()