» Indicating Due Payments, Based on the Current Date
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Absolute Beginner's Guide to Microsoft Excel 2002
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Personal Finance for Dummies
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft Outlook 2002 for Dummies
Due data
Sathish
a simple subtract formula and if operation could help you out
your set date subratcted by 60(no of days before due date) and then use this formula over there
=IF(N39<=N37,"Ripe","not yet")
Due Date
ALP
What formula should I use if I want to calculate the due date of "something" based on a received date? Help!
Thank you!
ALP
I have a set date in the future on my speadsheet (example 02/06/2011), i want the cell to tell me when that date is due to expire within 2 months, highlight in bold or something..... My boss is on my back so please HELP ! :