You used NOW() in B2 column to get the date. It is better to use TODAY().
Bebo I have a problem with formule in M1 - O1 ecc to connect them with cells in B2-B2000 where I have example if number in A is scanned give me date when it was scanned in column B
, when I insert dates in K1 , M1, O1, and so on and also everywhere (including B2-B2000) I put the same custom format gg-mmmm-aa, excel doesn't recognize it and sold products for that day are not extracted, do you have some idea why I can't get it work? When I use your file it seems to work when I don't enable to edit it, when I enable to edit, formula M1 =K1+1 doesnt work for me anymore, instead when for example 10-feb-2015 is in B15 and I direct M1 to =B15 it works , I dont know where I make a mistake, I everywhere inserted the same date or custom format, with dates I have generally a problem because I need to never change date after barcode scanning, I want to know when it was scanned, so I have also put iteration=1
Bookmarks