Thread: [Solved] help with formulate refers to values
View Single Post
 
Old 01-26-2011, 06:15 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi,

Sure, you can - just replace C2 in the formula with TODAY()
Code:
=IF(B2>TODAY(),
    DATEDIF(TODAY(),B2,"m")&" months "&DATEDIF(TODAY() ,B2,"md")&" days",
    "0 days")
However, I would recommend that you spare one cell in your worksheet for the TODAY() function and reference it from the formulas because:
1. This will give you more flexibility. For example, if you quickly wanted to see time remaining on contracts for a date other than today, you could quickly change the value in that one cell to see the results.
2. TODAY() is a volatile function. It is more efficient to structure the sheet this way.

Hope that helps...
Reply With Quote