Snasui Excel Forum

Hi there

I need to get day in dash .

I need the results in color cells by columns

simply formula would be appreciated

TY

What is the value in A4? Or provide more information about the result in A5:C5.

Thank you for your reply
I want to return in cell A3 and A5 base upon value in A2.

sna wrote: Sat Mar 26, 2022 9:47 pm A5 base upon value in A2.

What condition do you use for generating these values?

I just want to extract from dash and return from LEFT of lash until day at end of dash

TY

Please see the picture below. Where is 7 and why does the result show 7?

7 is the date between 1-8 Mar 2022
I don't need 1,2,...8
But instead I need only 1,7,8 only
If 1-18Mar 2022
1.would return from 1 to last day is 18
2.would return 1then last day 17,18
Ty

Try this,

1. A3
   =IFERROR(INDEX(ROW(INDIRECT(SUBSTITUTE(LEFT($A$2,LEN($A$2)-7),"-",":"))),COLUMNS($A2:A2)),"")
   Enter > Copy to the right
2. A5
   =MIN($A$3:$L$3)
   Enter
3. B5
   =LARGE($A$3:$L$3,3-COLUMNS($B5:B5))
   Enter > Copy to C5

Perfect,Thank you so much