Hi Mitzy........
Be advised that the TODAY() function is volitile, and will change as the
days/months/years change.......

Depending on exactly what you are going to use this for, you may need to
incorporate a Change-event macro to make the conversion, rather than a
regular formula..........

Vaya con Dios,
Chuck, CABGx3




"Mitzy" wrote:

How can you enter only the day number in a column ie 2 and have it come up as
date 02/02 or 2/2