Hi..I'm new here
I am looking for the serial number generation.
Can we generate serial number automatically basing on date change
For example i should make serial serial number from a given date and reflect on next adjacent cell as Ref_MMDDYYYY_001, here Ref is fixed which means reference rest is Month date year and 001 is the running number that increases if it the previous value in a column is the same date while it restarted to 001 again when there is a new date
December 22, 2019 - Ref_12222019_001
December 22, 2019 - Ref_12222019_002
December 24, 2019 - Ref_12242019_001
December 24, 2019 - Ref_12242019_002
December 24, 2019 - Ref_12242019_003
Bookmarks