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!

**View Complete Post**

## How can I calculate the Number of days between two dates Monday to Friday