» Indicating Due Payments, Based on the Current Date
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Column B contains the date of the last payment made by each of the clients listed in column A.
Payments are to be collected from each client every two weeks.
We want to indicate which clients have payments due today, based on the number of days since their last payment.
Solution:
Use the IF, MOD, and TODAY functions as shown in the following formula:
=IF(MOD(TODAY()-B2,14)=0,"Pay Today","")
Thus, the string "Pay Today" will appear next to each client whose payment is due today.
Book Store:
Recommended Books:
- Windows XP All-in-One Desk Reference For Dummies
- Personal Finance for Dummies
- Accounting Principles, with CD, 6th Edition
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
