Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Please find the attached file.
loveisfailstalwar1avinashelite@
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
sorry data missing
PFA
Hi,
This should help you. Do this with each list box
=Aggr(Only({<[Start Date]={"=Num(WeekDay([Start Date],0))<5"} >} [Start Date]),[Start Date])
Regards,
Luis
This show the reduction for Start Date for example:
Like this???
Please check this??
I am sure, you will get bulk thread which are opened and status got closed related same, Just start community before come to thread.. Good luck
Sorry all ,i not am getting correct output.
Here i am sending my original data.
I have 4 columns like
Event start date ,
Event start time,
Event Cancel date
Event Cancel time
here i need difference between
Event start date &Event start time - Event Cancel date & Event Cancel time. here i want remove the weekend days(Saturday ,Sunday)
,
ex:-
10/13/2017 | 23:00:00 | 10/16/2017 | 1:00:00 |
in this example Event start date &Event start time is 10/13/2017 23:00:00 and 14th,15th, is (Saturday,Sunday) no need to calculate this
and Event Cancel date& Event Cancel time 10/16/2017 1:00:00 A.M
Here example result is 2 hours.
Regards
Mahesh
May be this?
NetWorkDays(TimeStamp(Date#([Event start date] & [Event start time],'MM/DD/YYYYhh:mm:ss')),
TimeStamp(Date#([Event Cancel date] & [Event Cancel time],'MM/DD/YYYYhh:mm:ss')))
OR
NetWorkDays(Date(Date#([Event start date] & [Event start time],'MM/DD/YYYYhh:mm:ss'),'DD-MM-YYYY'),
Date(Date#([Event Cancel date] & [Event Cancel time],'MM/DD/YYYYhh:mm:ss'),'DD-MM-YYYY'))
Hi anil,
Its not showing correct output.
Regards
Mahesh