# Help W/Formula

#### Evagrius Ponticus

##### Well-known Member
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 . .

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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.

Last edited:

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

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

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?

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

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

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

Replies
8
Views
331
Replies
0
Views
1K
Replies
5
Views
426
Replies
1
Views
230
Replies
0
Views
266

1,203,521
Messages
6,055,890
Members
444,831
Latest member
iceonmn

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back