Days until close

[prush]

Hi, Fairly simple question I'm sure for the seasoned SF.com coder. 

I'd like to make a formula field that for my opportunities that calculates the number of days from NOW until the specified close date of the opportunity. Kind of like Age (  NOW() - CreatedDate) ), but the opposite direction. 

What would the formula be?

Any help would be great, thanks!

prush 

[Stevemo · Accepted solution]

Here you go, you probably want to stop counting once it is closed so I added an IsClosed check.

IF(NOT(IsClosed), CloseDate - TODAY(), NULL)

 

[prush]

Thanks a ton!

[Stevemo]

You're welcome, you owe me a beer!

http://beeradvocate.com/beer/profile/863/7971/