bhaiyo aik file attach ki hai aik formula chaee. working days ka or holi days ka pls help
286197
bhaiyo aik file attach ki hai aik formula chaee. working days ka or holi days ka pls help
286197
Mera Peghaam Mohabbat hai jahan tak pohanchy
وعلیکم السلام
محترمہ تھوڑا سا اگر ایکسپلین کر دیں تو بہت اچھا ہوگا۔
سکرین شارٹ دے دیں کہ مجھے یہاں یہ چاہیئے۔۔اوکے
[FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]
sister ap explain krein...
plzzz ....takke solution batane m asaani ho....
ap ye thrd chck kren Inshahallah ap ke prblm slve ho jae ge
CLICK HERE
IN cell AJ2 for absence check copy and copy down as far as required
In cell al2 for presense check copy down as far as requiredCode:=COUNTIF(D2:AG2,"a")
for total leaves copy above formula and change "P" and "A" with letter use for leave.Code:=COUNTIF(D2:AG2,"p")
may be its will help you for further detail see the above link mentioned.
aur dusra mujh ko samjhai k keya working days maloom karne se aap ka matlab ha ka sunday exclue karain aap k date range se.
...........
Last edited by *Xpert~Baba*; 30th July 2012 at 08:12 PM. Reason: dont post wrong section
Bookmarks