Days left formula sharepoint 2010

Question

 Hi,

I want to calculate the days left. I know I can't use [TODAY] in column.  In a simple way, I would like to have a column name "Days left" and this column have to calculate this : expireDate-Today. But, I don't know how to do this. Somebody can help me please?

Thanks

Answer 1

Hi,

I am not sure if this is what you are looking for, but here is the simple solution:

Create column 1 (let's say TODAY) and set column tyoe as date, with required set to yes and default value set to Today.

Create column 2 (EXPIRY DATE), type = date, enforced =  yes

Create column 3 (DAYS LEFT), type calculated, formula you need is =[EXPIRY DATE]-[TODAY]

Hope this helps,

---

LW

Answer 2

Thank you! I will try it :)