| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatic month/date in a column
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatic month/date in a column
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 -- Gary''s Student gsnu200703 "Mitzy" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatic month/date in a column
A1 =2
B1 =DATE(YEAR(TODAY()),A1,DAY(A1)) format cell as m/d "Mitzy" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatic month/date in a column
=DATE(YEAR(TODAY()),MONTH(TODAY()),A1)
"Mitzy" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatic month/date in a column
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 "Mitzy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
