View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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