If you format the cell where the date is entered as 'number' then this gives
a unique number. However I suspect what you need is not so simple and
therefore requires fuller explanation please.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"stephanieylalo" wrote:

how do i use the date function to insert a formula that inserts a serial
number for a specific date