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
|