ddate

  1. N

    Entering date as "DD/MM/YYYY@;" but result is with "DD-MM-YYYY"

    Hello Trying to enter Date as .NumberFormat = "dd/mm/yyyy;@" but result displays as "dd-mm-yyyy" Dont understand why below for the reference Code in thisWorkbook Option Explicit Private Sub Workbook_Open() Dim ws As Worksheet Set ws = Worksheets("Sheet2") ws.Range("A:A").NumberFormat =...
  2. R

    VBA fast way to delete rows in a 2-column range if the date is less than a defined date

    Hello everyone, I've defined a "Ddate" as being "Now()+14" I have a set of data on "Temp" sheet which has 2 columns. A is string and B is a list of dates. What I need to do is quickly run down these ~3,000 rows and delete any row where the value in B is less than or equal to "Ddate" I've...
  3. S

    Force Date Format for a User Form

    Hi folks, I have inherited an evaluation form and have a couple of improvements I want to do to it. There are 2 date fields on the form, Session Date and DOB. There is no formatting control on this so I want to force the date entered to be formatted correctly and throw a message box up if...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top