Page 1 of 1
Date
Posted: Thu Dec 10, 2020 4:50 pm
by sna
Hi Dear,
I have dates in both cells
A1=1/1/2001
A2=31/4/2001
I want to get result in column B start in :
B1=Jan-2001
B2=Feb-2001
B3=Mar-2001
B4=Apr-2001
Could you give me Formula?
Kind regards
Re: Date
Posted: Thu Dec 10, 2020 5:21 pm
by puriwutpokin
B2=TEXT(A1,"[$-en]MMM-YYYY")
Re: Date
Posted: Fri Dec 11, 2020 6:34 am
by sna
No.I don't need that.I want to get month from Jan To Apr base on Date 1/1/01 30/4/01
I mean to get month range from A1& A2
If A1
1/1/01
A2
30/4/01
It should range month in
B1
Jan
B2
Feb
B3
Mar
B4
Apr
If A1: 1/1/01
A2:31/3/01
So
B1:Jan
B2:Feb
B3:Mar
Kind regards,
Re: Date
Posted: Fri Dec 11, 2020 8:22 am
by puriwutpokin
Try it
B2=IFERROR(TEXT(DATE(YEAR(A$1),INDEX(ROW(INDIRECT(MONTH(A$1)&":"&MONTH(A$2))),ROWS(B$1:B1)),1),"[$-en]mmm"),"") copy down
Re: Date
Posted: Fri Dec 11, 2020 9:44 am
by sna
Thank.It is working