Thread: automatic month/date in a column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote