|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
04-24-2007, 10:55 AM
|
|||
|
|||
|
DATEDIF Formula
I am working on a pproject that I need a formula to count down contract dates. I have a column with the contract sign date and a cell (located at A1) will the current date. I need to be able to count down the remaining time left on each particular contract. Could someone share some info on a formula for this task please?
|
|
#2
04-24-2007, 11:09 AM
|
||||
|
||||
|
Try
=DATEDIF($A$1,B2,"d") where A1 house formula =TODAY() B2 house 1st contract date... copy formula down. Note, you can replace A1 in the formula with Today().
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#3
04-24-2007, 04:09 PM
|
|||
|
|||
|
Thanks alot for the info.
I believe I need to calculate in the contract length somewhere in this formula somehow. I do have a column that states the length. Most range from 3-5 years. It is giving me an error #NUM! in the formula cell (=DATEDIF,TODAY(),B2,"d"). I assume this is because it needs a contract length in order to determin the time remaining.
|
|
#4
04-24-2007, 04:13 PM
|
||||
|
||||
|
Quote:
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
