View Complete Post
I have a calculated column in a list called Days Open. This column contains the number of days between today (Sysdate) and another column called the Effective Date. Therefore, if Sysdate is 11/16/2010 and the Effective Date is 10/14/2010,
how do I calculate the number of days between the two dates?
I tried using this formula: =TEXT(Sysdate-[Effective Date],"h")
and then I tried =INT(Sysdate-Effective Date) & TEXT(Sysdate-Effective Date, ":hh:mm")
Neither formula worked. I hope it is something real simple that I am missing here. Any help you can provide will be highly appreciated!
I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.
I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.
Please help me guys... It will be a great help...
The Excel Services architecture lets users design their own algorithms and share workbooks on a server.
Vishwas Lele and Pyush Kumar
MSDN Magazine August 2007
how do I go about generating formulas for something like this.
I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High =
1 day, exclude weekends.
Is there anyway where we can use KPI list to attach to a SharePoint list and indicates which item was clicked the most ? Or any other way to find out the best 5 links based on how many times they were accessed by a user?
Thanks in advance
does any1 know if there is a webpart that can calculate an employee's vacation days. and when the employee request some vacation days it show the days that are left.
or is there a tutorial to create such a webpart?