DATEDIF Formula

[kwright90]

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?

[NBVC]

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().

[kwright90]

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.

[NBVC]

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.

It should be =DATEDIF(TODAY(),B2,"d") where B2 is a date greater than or equal to today's date (i.e. in the future).

[kwright90]

Ok... Thanks alot!!

B2 being the "Contract END Date"....

Got it!!