Help with fine tuning formula - date lookup concantonate

sleepers

Board Regular
Joined
May 26, 2004
Messages
203
Hi i have this great script that looks up my availabilities sheet and makes a nice avails roster which shows the dates available in a month etc

i need to be able to control which days show - eg. i only want fri and sat to list and bypass the thu and sun from the availabilities sheet.

avails setup
http://www.whirlwindent.com/test/avails.pdf


output
http://www.whirlwindent.com/test/output.pdf

code on output page
=IF(ISERROR(concatmth2(INDIRECT(I$5),C10)),"",(concatmth2(INDIRECT(I$5),C10)))

script
Code:
Function ConcatMth2(rng As Range, item As String, Optional dte = True)
    Application.Volatile
    For Each ce In rng
        If ce <> "" And Sheets(rng.Parent.Name).Cells(2, ce.Column) = item Then
            If dte Then
                holder = holder & Format(ce, "ddd d") & ","
            Else
                holder = holder & ce & ","
            End If
        End If
    Next ce
    ConcatMth2 = Left(holder, Len(holder) - 1)
End Function
[/code]

i need to be able to select the days i want and then the months will only show those variables?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,251
Members
412,709
Latest member
Rishu
Top