Hi,
I have excel sheet which consist of attendance data.
i want to calculate no of working days, present days, Planned leaves, per day salary
how to count to present days in excel.
Attendence.xlsx (13.6 KB)
Please check this excel sheet and please provide .xaml file which could be really helpful
Regards
Sai
Anil_G
(Anil Gorthi)
2
@Sai.Srinivas
For all these operations you dont need to do from UiPath…all of these are directly available on excel itself…
You can use countif,Sum and other formulae as needed to calculate all of these values directly on excel itself
Cheers
@Anil_G
I want to count no of p in UiPath. How to do it and let me know in UiPath and also if morethan 3 PL then i need to make abscent for 4th PL
arivu96
(Arivazhagan A)
4
HI @Sai.Srinivas
Apply Excel Formula in cell
=COUNTIF(N2:AR2,"P")
Regards,
Arivu
2 Likes
How to do using Datatable not in excel can u provide .xaml file
Hello @Sai.Srinivas
You can achieve this by Excel formulas and autofill activities.
refer the Excel sheet2 for Formula
Attendence.xlsx (15.8 KB)
Refer to this Thread to know more about the Autofill formula
arivu96
(Arivazhagan A)
7
Hi @Sai.Srinivas ,
Refer below xaml file.
Attendance.xaml (11.0 KB)
Regards,
Arivu
arivu96
(Arivazhagan A)
9
Hi @Sai.Srinivas ,
Use updated xaml file
Attendance.xaml (16.2 KB)
Regards,
Arivu
2 Likes
system
(system)
Closed
10
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.