PLEASE HELP
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()
|