automatic month/date in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Format > Cells... > Number > Custom
"2/"General

If you are willing to use 2 cells, then in A1 put
2
and in B1 put:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A5)

this formula will adjust for the current month and year
 
Hi Mitzy........
Be advised that the TODAY() function is volitile, and will change as the
days/months/years change.......

Depending on exactly what you are going to use this for, you may need to
incorporate a Change-event macro to make the conversion, rather than a
regular formula..........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

How to get largest date from a Vlookup 1
Help with Excel 2007 COUNTIFS! 0
Access Running Balance in Access 1
Unhide column difficulty 3
Count a value excluding duplicates depending on a set criteria 1
copying_data_using_FillHandle 1
Add 2 days before and after birthdate 4
Date Function 2

Back
Top