Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one table in which Total holidays dates are present,
i want total working days to count which is Count(Total Days of Month) - Count(Holidays)
getting some glitch in output pls suggest.
pls find the attached sample data for holidays
I want to understand what result you are looking for?
Don't want so many replies for a simple question...
Pls find the attachment of sample working and output expected
hi Deepak,
i have holidays including Sunday and Holidays. only require to do let say jan has 31 days and holidays are 7 in any plant
so in that plant ouput expexted is 31-7 = 24
hope i m clr now
I hope, this solution is correct.
Application in attachment.
Hi,
Try this expression
=MonthEnd(Min({< Flag = {'Calendar'}>} [Calendar Date])) - MonthStart(Min({< Flag = {'Calendar'}>} [Calendar Date]))
For Total Month Days
Hope this helps you.
Regards,
jagan.
HI Jagan,
if i am in feb now and till now only 11 total days are there and one holiday is applicable, so for that output shud come 10
but i am getting 29(total days on feb)- 4(total holidays of feb). how to include this?
Hi,
Try like this
=If(MonthName(Min({< Flag = {'Calendar'}>} [Calendar Date])) <> MonthName(Today()),
MonthEnd(Min({< Flag = {'Calendar'}>} [Calendar Date])),
Min({< Flag = {'Calendar'}>} [Calendar Date]))
-
MonthStart(Min({< Flag = {'Calendar'}>} [Calendar Date]))
thanks for revert, but its
giving me wrong output, till now feb has 11 days and there is 1 leave so it shud give 10 working days, it is giving me 6.
and one more thing want to add, i am looking all this as per fiscal year
thanks for ur help,but seems not fulfill
In Jan there are 31 days and in ur code its 30 and if i m in feb, than it is taking full Month days i.e 29 but currently in feb there are 11 days, so before 11 days only one holiday than count shud be 11-1= 10.
pls suggest
HI,
Try like this
=If(MonthStart(Min({< Flag = {'Calendar'}>} [Calendar Date])) >= MonthStart(Today()), Today() + 1,
MonthEnd(Min({< Flag = {'Calendar'}>} [Calendar Date])))
-
MonthStart(Min({< Flag = {'Calendar'}>} [Calendar Date]))
Regards,
Jagan.