compare dates

  1. A

    VBA Code to compare Dates, then run macro to match colums

    Hi, Hope I can get some help with adding code to loop through the dates in column A of Sheet1 & compare them to the dates in Column A, Sheet2. If the date on Sheet2 is greater than Sheet1 run the MatchColumns macro. Sheet1 accumulates jobs with recommendations through out the year. Sheet2...
  2. M

    Compare several dates in row and display the most recent date

    First I am sorry if this has been asked previously but I could not find anything that helped me out. I have a spreadsheet that is about 500 rows and part of it includes 8 columns representing the last 8 years. In some of the columns there are dates and others are blank. I want to compare all 8...
  3. C

    Need Fiscal Year/ Calendar Year matching days formula!! Please help!!!

    I work in grant budgeting and need to calculate fiscal year budgeted amounts based off of calendar year budgets. Usually the amount of calendar year days hits multiple fiscal years. See below; <tbody> Calendar Year Total Days Fiscal Year Total Days Days in CY 365 350 0 715...
  4. M

    Compare date in a cell to TODAY and have msgbox if date is in the past

    Hi All, I have a cell in my sheet where the user will insert a date. If this date is in the past i would like a msgbox to open and inform them of this. I feel like this should be really easy but i just can get it working. Thanks in advance for any help, Mike
  5. B

    Date comparison in excell

    I have a table that has 14 tabs. One for each of the months and 2 summary pages. On each of the months tabs I have data in cells G9:G18. On one of the summary pages I am trying to pull said data into it from the 12 months tabs, but only want the previous months and the current months data...
  6. W

    Flag several duplicate columns that occur within a 3 day range.

    Hi, I have the following named Ranges Activity ID Numeric, Unique --Key Field Customer Name Name Customer ID Numeric, Ticket ID Numeric ClosedDate1 Date AgentID1 FLast SCIP Event Yes / No What I am attempting to do, is Flag...
  7. G

    Checking date ranges

    I am trying to create a spreadsheet which contains a list of bills, such as Gas, Electric, telephone etc., each of which is payable on a set day each month. The spreadsheet lists these bills in the first column, and then has a column for each week of the year, with Monday as the first day of the...
  8. B

    Expirity Date Compare

    Hello Again, I want macro to check the expiry dates. Range (H2:H12) has the expirity dates of listed drugs. I want code to check the expirity dates and if it is less than 60 days left highlight the date and drugname (which is in B column) in bold and green. If it is less than 30 days left...
  9. pedie

    Compare the dates: if <> then run my code: Please help: Thank you.

    Hi, What I am looking to achieve is that if any of the date in range D:D of activeworkbook = date in k2 of book2 then exit sub or run my code. With thanks Pedie:)
  10. F

    Formula to Make Overdue date record highlighted in field

    I have created a spreadsheet for samples In and Out of our shop. I have the following fields:- <table x:str="" style="border-collapse: collapse; width: 342pt;" width="455" border="0" cellpadding="0" cellspacing="0"><col style="width: 67pt;" width="89"> <col style="width: 81pt;" width="108">...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top