date comparison

  1. C

    AutoPopulate Records Based on Dates

    I have a budget forecast workbook where I track my upcoming recurring bills along with all my transactions - be it cash, ATM, check, etc. This also includes any deposits. It is basically an electronic check register with a budget forecast function. There are three ways I gather/enter data: 1)...
  2. T

    Formula to read "TRUE/FALSE" results from other formulas, issue with blank cells read as "TRUE" results for date comparison formula

    I think I'm over-complicating a series of formulas I wrote to save time for myself. My job is to e-mail the customer each week when Task A or Task B is completed on Projects A-F. The real spreadsheet has dozens of tasks and it's time-consuming to filter column-by-column for new dates, so I'm...
  3. A

    Date Column Comparison, Odd One Out

    I am currently scouring and plugging numbers from years prior into a spreadsheet for graphical purposes and as such have numerous date based cells assigned individualized data. Now, the data points I am pulling from aren't exactly what you would call 'consistent' and miss quite a few days here...
  4. M

    VBA - date comparison and copy

    This is my first post so please have patience with me. I have a work book with 4 tabs: Pivot Summary, Imported Data, Missed Job Data and Yesterday. I import data from an external source to the Imported Data tab. Then refresh data on a pivot table via the Pivot Summary sheet. On the Pivot...
  5. A

    Copy formula paste value

    Hi, I'm pretty new in the VBA World and was hoping somebody could help me with this problem. I have two worksheets: "worksheet1" containing the current data (e.g. today's progress) I want to copy and "worksheet2" containing historical data (e.g. historical progress) in which I would like to...
  6. D

    Date Comparison to Highlight Cells

    Hi All, I'm working on a job booking system and I'm looking to create an if statement to highlight cells that have gone past the expected finishing times. In the 'D' collumn I have the date the job is expected to finish as DD/MM/YYYY, and in 'K' collumn I have a similar set up that people...
  7. J

    date compare problem

    I need assistance in figuring out how to compare a literal to a cell that actually references another cell. My literal comparison is checking for which day of the week is in a cell. For example, let's say cell address 'A1' contains the date in the following format: 'day, month day, yyyy' format...

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