comparing dates

  1. C

    Comparing due dates with completion dates

    Hi there, first time poster here. I'm sure there is a simple solution here but I hope someone in the group can help me. I built an application that tracks requests made by clients. When we receive a request, a due date is generated. When our agents submit their work, the date of completion is...
  2. E

    Comparing two columns with dates using conditional formatting

    Good Morning, I am looking to compare two dates in columns F and I. If I is more than 3 days after F then I would like it to have it change colors. I have tried everything but have been unsuccessful. Please help! Thank You. Erin
  3. O

    Comparing a date on sheet with a date in textbox

    Hi All! I have a little comparison on a userform: If TextBox72.Value = Cells(ActiveCell.Row, "AJ").Value Then msgbox "Dates are the same" else msgbox "Dates are different" end if Where both textbox72 and Cells(ActiveCell.Row, "AJ").Value are dates. The problem is that it is returning...
  4. D

    VBA Help on Date Validation that compares on the date today and will be highlited

    Im using Excel2007 and i have a sheet and a button that checks or compare the date i enter with the date today example Name sex validation today doms male 03/30/11 04/26/11 nicas fema 04/26/11 04/26/11 congi male 04/29/11 04/26/11 then if the date today and the date of validation will be...
  5. R

    Comparing Dates

    Hi… <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am comparing two dates— the first date is the current system date and the second date is in column G starting at row 2 through row x. I need to determine if the system date is past the date in Gx or...

Watch MrExcel Video

This Week's Hot Topics

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
Top