E
Esra
anybody got any ideas how i can display a lit of dates in cells a2:a32
that are the dates of the month in cell a1?
that are the dates of the month in cell a1?
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.
T
T. Valko
the dates of the month in cell a1?
How is the month entered in the cell?
As the month name as a TEXT entry: January or Jan
As a true Excel date: 1/1/2008
As the number of the month: 1
???
How is the month entered in the cell?
As the month name as a TEXT entry: January or Jan
As a true Excel date: 1/1/2008
As the number of the month: 1
???
E
Esra
The month in cell a1 says January, or Febuary, or March,,,,,,
F
Fred Smith
And what do you want as the date result? The first of the month? the end of
the month? The current year? or some other year?
Regards,
Fred.
the month? The current year? or some other year?
Regards,
Fred.
T
Teethless mama
In A2: =TEXT(DATE(YEAR(TODAY()),MONTH($A$1&1),ROW(A1)),"m/d/yyyy")
T
T. Valko
Try this:
A1 = month name as a TEXT entry: February
Enter this formula in A2:
=IF(A1="",TODAY()-DAY(NOW())+1,--("1-"&A1))
Format as DATE
Enter this formula in A3 and copy down to A32:
=IF(MONTH(A$2+ROWS(A$3:A3))=MONTH(A$2),A$2+ROWS(A$3:A3),"")
Format as DATE
These formulas will return the dates for the month entered in A1 of the
*current year*.
A1 = month name as a TEXT entry: February
Enter this formula in A2:
=IF(A1="",TODAY()-DAY(NOW())+1,--("1-"&A1))
Format as DATE
Enter this formula in A3 and copy down to A32:
=IF(MONTH(A$2+ROWS(A$3:A3))=MONTH(A$2),A$2+ROWS(A$3:A3),"")
Format as DATE
These formulas will return the dates for the month entered in A1 of the
*current year*.
E
Esra
I never thought that such as simple question could turn out to be so
hard. It must be how i am describing it.
In cell A1 I want to enter a month, i guess i will have to also put a
year, not sure how i would ebnter that but am open to suggestions.
Then in the subsequent 31 cells below a1, i wish the dates to be put.
I would like format for date to be Tuesday 1st April. I dont need the
year, but realise I will have to have that there to tell what day of
the week it is.
eg:
April
Tuesday 1st April
Wednesday 2nd April
Thiursday 3rd April
,,,
,,,
,,,
,,,
Thuirsday, 30 April
I realise only 30 days in April and not 31, but can manually delete
unrequired dates
Does that make sense now?
Sorry about confusion.
Esra
TIA
hard. It must be how i am describing it.
In cell A1 I want to enter a month, i guess i will have to also put a
year, not sure how i would ebnter that but am open to suggestions.
Then in the subsequent 31 cells below a1, i wish the dates to be put.
I would like format for date to be Tuesday 1st April. I dont need the
year, but realise I will have to have that there to tell what day of
the week it is.
eg:
April
Tuesday 1st April
Wednesday 2nd April
Thiursday 3rd April
,,,
,,,
,,,
,,,
Thuirsday, 30 April
I realise only 30 days in April and not 31, but can manually delete
unrequired dates
Does that make sense now?
Sorry about confusion.
Esra
TIA
E
Esra
PERFECT, exactly what I wanted. Thank you so much.
Esra
Esra
T
T. Valko
You're welcome. Thanks for the feedback!
I
Ivyleaf
Hi,
Just for the hell of it:
in cell A2: =DATEVALUE("1-"&IF(A1="",MONTH(NOW()),A1))
in cell A3: =IF(DAY(IF(A2="",0,A2)+1)>DAY(A$2),A2+1,"")
Drag A3 down to A32.
Cheers,
Ivan.
Just for the hell of it:
in cell A2: =DATEVALUE("1-"&IF(A1="",MONTH(NOW()),A1))
in cell A3: =IF(DAY(IF(A2="",0,A2)+1)>DAY(A$2),A2+1,"")
Drag A3 down to A32.
Cheers,
Ivan.
I
Ivyleaf
Hi Again,
Actually even shorter would be:
in Cell A2: =--("1-"&IF(A1="",MONTH(NOW()),A1))
That double minus sign's a nifty trick Biff! You learn something new
each day!
Cheers, and thanks again Biff.
Ivan.
Actually even shorter would be:
in Cell A2: =--("1-"&IF(A1="",MONTH(NOW()),A1))
That double minus sign's a nifty trick Biff! You learn something new
each day!
Cheers, and thanks again Biff.
Ivan.