Help W/Formula

[Evagrius Ponticus]

Hi all . .

I need a formula that would count down 9000 days starting on July 2nd 2008.

example on July 3rd it would read 8999

I've been working of it but can't seem to get it right . .

 

[BAlGaInTl]

Try this where A1 contains your start date (Jul 07 2008).

=9000-DAYS360(A1,TODAY())

edit:

Here is the same thing with the date built in to the formula:

=9000-DAYS360(DATE(2008,7,8),TODAY())

edit again...

Duh.. I'm stupid today... that assumes a 360 day year for accounting purposes. I will see what I can come up with that doesn't have that limitation.

 

[BAlGaInTl]

Try this instead:

=9000+(DATE(2008,7,8)-TODAY())

 

[Evagrius Ponticus]

Thanks for the reply - so on July 2 - will this formula start counting down from 9000?

This is what I started with I just can't figure out how to make it work without hardcoding the date - D8 is July 2 . .

=9000-RIGHT(VALUE(D8))

 

[BAlGaInTl]

Thanks for the reply - so on July 2 - will this formula start counting down from 9000?

This is what I started with I just can't figure out how to make it work without hardcoding the date - D8 is July 2 . .

=9000-RIGHT(VALUE(D8))

=9000+(D8-TODAY())

Will do the calculation. Are you saying that you don't want the counter to start until the date in D8 passes?

What do you want it to display until that time starts?

 

[Evagrius Ponticus]

I am an idiot - sorry for the error - I need it to start counting down from 9000 begining on July, 2 2008. So July 3rd 2008 should be 8999

 

[BAlGaInTl]

This formula will show nothing in the cell where you put it until the Date in D8. Then, it will count down each day from there.

=IF(TODAY()< D8,"",9000+(D8-TODAY()))

 

[Evagrius Ponticus]

Actually, I think your previous response was what I was looking for . .

=9000+(DATE(2008,7,8)-TODAY())

Thank you so much for the help . . .