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 |