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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Template with fields and premade texts.. 0
Function help 7
Modifying a complex date formual to count months 4
time_report_date-wise_employee-wise 6
Auto Merge text from multiple sources 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
IF AND Function Date Range Issues 6

Top