Thread: automatic month/date in a column
View Single Post
  #3   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
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
Reply With QuoteReply With Quote