1st of April or 4th of January unless I see one of the dates in the column (which could be many many rows long, most being off screen) meeting this condition.

I usually avoid any date format with “dd/mm” in it because when people see a date is it “dd/mm” or “mm/dd” you’re looking at? Unless dd is > 12 I cannot be sure if it’s showing me e.g. You can of course choose whatever date format you wish.

So for this example, you would need to use the formula –īonus comment about displaying (or barcoding) dates: The way get the date format into the barcode is to use the TEXT function to show the date in the format you want. So when you assign a cell a value which you set the font to “FREE 3 of 9″ barcode font (or the extended version), the formula you would have is –įor dates, the above formula results in output like *43466* instead of **. If you don’t do this, the barcode won’t work. When using barcode (at least ‘3 of 9’) you need to start and end it with an asterisk (*) character. If A1 contains your date, either using a formula or merely entered as a date, and you need to choose a suitable format for excel to show that date. You have to be careful which date format you pick for dates when using them in a barcode. I’ve been a bit verbose but hopefully it will explain what I think your question is asking. Just saw your query post from the beginning of the year (by accident than deliberate looking).

Windows 10 excel 2016 download free