extract dates

  1. C

    capture numbers from date

    Hi. My issue relates to showing a date without separators (15/04/13 becomes 150413) My business has a weird way of saving files & is very picky about it being spot on. it is date;location code;activity. I am going to collect the data from the sheet so that I can automate the process of saving. I...
  2. L

    COUNTIFS dates match, dates as numeric but in text cell with many other numbers

    Hi, again thanks for previous help, I would not ask had I not tried several times already, but my new question is this: I have a column listed as the ID tag for a dataset. This column has a large number for every row, with numbers representing different values of the identification, and...

Some videos you may like

This Week's Hot Topics

Top