Thread: Date / month / year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Date / month / year
On Sun, 6 Apr 2014 07:33:12 -0700 (PDT), wrote:

Hi Is there a formula for entering the month and year automatically. So if i just enter 06 for example this then changes to 06/04/14 ?

If you enter 6 in A1, try:

B1: =date(year(today()),month(today()),a1)

Reply With QuoteReply With Quote