greater than date

  1. N

    Formula for date error checking if a certain date is greater than another

    Hi all, I work in a business where we have a date driven process. As happens with all data, however, sometimes entry errors happen. I want a formula that will check to make sure that the second record date (AE) is not greater than the first record date (AC). However, when I write the formula...
    • Nathag
    • Thread
    • date formatting greater than date if statement excel less than
    • Replies: 3
    • Forum: Excel Questions
  2. R

    Multiple criteria greater than

    Hello experts, I have different license plates belonging to various companies, but that can be "drafted" to other companies. It is easier to explain it sample data: <tbody> License Plate Company Start Date A1 AAA 01-01-2017 A2 AAA 01-01-2017 A2 BBB 01-12-2017 </tbody> On another sheet...
    • Ruca13
    • Thread
    • aaa company greater than date license multi criteria
    • Replies: 7
    • Forum: Excel Questions
  3. M

    Formula help please, IF function with GREATER THAN TODAY minus 30 days

    I'm currently using a formula to act as a prompt to contact people who are overdue or not current members and want to change it to prompt about a month before their membership runs out. I know I could add an extra column for the due date and use DATEDIF but I'd rather keep fewer columns on the...
  4. B

    Conditional Formatting 'greater than/less than' for cell containing variable date based on a formula

    Please please please someone help! I have a spreadsheet as below. A2 - 'Date Approved' is manually entered, B2 - 'Review Date' and C2 - 'Trial Expiry' are automatically calculated based on the date entered in A2 - 'Date Approved'. I need to conditionally format as follows: B2 - Cell to turn...
    • Bekker
    • Thread
    • conditional formatting date calculation greater than date less than greater than variable dates
    • Replies: 1
    • Forum: Excel Questions
  5. A

    Countifs with a regular criteria and a criteria with a date

    Hi everyone, Firstly, thanks for reading my question. I have an issue where I would like to count the number of classes per subject that have occurred since a date. This table shows the subjects that I would like to count: Sheet1 <colgroup><col style="font-weight:bold; width:30px; "><col...
  6. S

    IF Date is Greater than Another Date Then

    Working in Excel 2007 I am trying to determine how to write a formula for a scenarios when a date is greater than (1/1/2013) another date in same row, but a different cell. So for example if date in Column C is occours(ed) before date in Column B then I want to enter a zero in Column D to...
  7. K

    Greater Than in an IF(AND forumula

    I know this should be easy, but i'm having no luck. I want to say If column A is "N" and Column B is greater than 10-July-2011 display a Y I would think it should be something like: =If(And(A1="N",B1>10-JUL-11),"Y","N") but this results in #NAME? I know the problem is with my date, but i've...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top