# due dates

1. ### Overriding Conditional Formatting Color with Manual Entries of a different color

Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...
2. ### Drop down lists with formulas

Hello, I created a spreadsheet that tracks invoices we have funded a different bank account. I am wondering if there is a way to create a drop down list that can calculate due dates based on their terms? INVOICE NUMBER CUSTOMER INVOICE DATE DUE DATE INVOICE AMOUNT PAID AMOUNT OUTSTANDING...
3. ### Conditional Formatting Dependent on Dates

Hi, I have 2 date columns in my worksheet, E and F. If 14 days have passed from the date entered in column E and there is no value in column F I would like the cells in column F to turn red. I tried to use the below formula but it doesn't seem to be working. Also when I click and drag the...
4. ### Calculating a Due date with Different frequency

I need a formula that can tell me the next due date if I have the first due date, the frequency the payment is being paid (Monthly, Weekly, Semi-monthly) and the number of payments that are setup. Column D is the first Payment date, Column E is the frequency, Column F is the number of payments...
5. ### Past due dates

I have a sheet that I am trying to calculate days past due. I=Date Due J=Days Past Due K = Date Implemented I want to calculate the days past due, stopping counting once the date implemented is entered and I need to ignore blank cells. I have a formula that works to stop counting after the...
6. ### If Due Date < Entered Date = Yes, If Due Date > Entered Date = No

Hello, First time poster and I have a quick question! I am essentially trying to create a formula that will determine if someone has met their due date based on the expected due date vs actual completion date. I would like it to generate a yes or no (or something of that variation) so I can...
7. ### List of Due Dates from Part Payment events

Hello Experts, I am looking to create a single list which remind me of upcoming payment due dates (Columns: Due Date, Amount, Vendor Name, Approved Date) (it will populate information from the below table which Payment Requestors and Accountants Fill) Below Table shows, Requestor Fills first...
8. ### Create a macro button to show due dates "this week" or "this month"

Hello, I am trying to create a macro button that shows due dates for "this week" and "the next two weeks" and "next month". I have delivery due dates in column K in a spreadsheet and at the click of a button, I would like to display only the rows that have due dates for this week, etc. Also...
9. ### Next Due Date

Hi guys, I'm kind of an Excel Noob and have been struggling with this for a couple of days I hope someone can help. I have a spreadsheet used to track "Visit Due Dates". There are 4 visits required a year 1 annual and 3 quarterlies, all based on an "Approval Date". I would like to find a way to...
10. ### If/Then using a due date for a bill

I've been pulling my hair out all day... so I figured I should finally break down and ask someone. I keep a spreadsheet for my bills (who doesn't, I know). On it, I've always either copy/pasted the "Amount" in the applicable cell for when a bill is due, or a cell reference (in case it changes...
11. ### Formula to track expiration Dates by color

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->I am in the military and work in an armory. I have a spreadsheet in excel 2010 to track members qualifications. In column A I have all the names of everyone at the unit. Each column after that...
12. ### Upcoming due dates

I am in the military and work in an armory. I have a spreadsheet in excel 2010 to track members qualifications. In column A I have all the names of everyone at the unit. Each column after that represents a type of qualification. For example column B is basic weapons quals. There is a different...
13. ### Conditional formatting

Hey, http://www.mrexcel.com/tip054.shtml I was wondering that the tip you have provided in the above web site can have 3 conditions. Would it be possible that once the day passes by the color changes to blue. This is because my page gets overcrowded with red background cells. Thanks
14. ### Conditional Formatting

Hey there. I'm a newbie to excel and can't find anything to help me. Here's my dilema: Mr. Snuffy completes a course on 13AUG08 and hands me a certificate. I put the complete date of that certificate in a cell. When I open excel, from 14AUG08 until 13MAY09 (9mos) I want it to stay white. On...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back