» 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:
- Financial Risk Manager Handbook, Second Edition
- Microsoft Word Version 2002 Inside Out
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Definitive Guide to Excel VBA
No comments have been submitted.
