» Indicating Due Payments, Based on the Current Date
CATEGORY: Excel Date & Time Formulas |
VERSIONS: 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. |
Due data
Sathish wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
What formula should I use if I want to calculate the due date of "something" based on a received date? Help!
Thank you!
ALP
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.






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 ! :