ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date / month / year (https://www.excelbanter.com/excel-worksheet-functions/449984-date-month-year.html)

[email protected]
Date / month / year
 
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 ?

Ron Rosenfeld[_2_]
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)


All times are GMT +1. The time now is 12:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com