Date / month / year

H

hobcosales

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 ?
 
R

Ron Rosenfeld

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 ?
Click to expand...

If you enter 6 in A1, try:

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