M
Mitzy
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
date 02/02 or 2/2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
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
"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
T
Teethless mama
A1 =2
B1 =DATE(YEAR(TODAY()),A1,DAY(A1))
format cell as m/d
B1 =DATE(YEAR(TODAY()),A1,DAY(A1))
format cell as m/d
T
Teethless mama
=DATE(YEAR(TODAY()),MONTH(TODAY()),A1)
C
CLR
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
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