automatic month/date in a column
 

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

automatic month/date in a column
 

Format Cells... Number Custom
"2/"General

If you are willing to use 2 cells, then in A1 put
2
and in B1 put:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A5)

this formula will adjust for the current month and year

--
Gary''s Student
gsnu200703


"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

automatic month/date in a column
 

A1 =2

B1 =DATE(YEAR(TODAY()),A1,DAY(A1))

format cell as m/d



"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

automatic month/date in a column
 

=DATE(YEAR(TODAY()),MONTH(TODAY()),A1)


"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

automatic month/date in a column
 

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