Dates remove

[qlikview979]

Hi Experts,

Please find the attached file.

loveisfail‌stalwar1‌avinashelite‌@

I have two columns like Start Date,End date  like number of rows but i want to remove Saturday,Sunday Dates.

I want show to only Monday to Friday dates in List box.

Regards

Mahesh

[Anil_Babu_Samineni]

I just opened your excel, In excel the format looks like time period, may be try this? I don't have software to load your source

NetWorkDays(Date(Date#([Event start date] & [Event start time],'MM/DD/YYYYhh:mm:ss TT'),'DD-MM-YYYY'),

Date(Date#([Event Cancel date] & [Event Cancel time],'MM/DD/YYYYhh:mm:ss TT'),'DD-MM-YYYY'))

[qlikview979]

Thanks for your help Anil.

not showing  data in list box.