help with counting down to a date in excel

  • Thread starter Thread starter Forrest
  • Start date Start date
F

Forrest

i am trying to count down in days to a specific date i have the date in block
b2 and todays date in A1, but dont know the formula. any help is great thanks
 
What does the date block (ie, b2) look like? What do you mean by "count
down"?

Regards,
Fred.
 
A1 - =NOW()
B2 - Target date

(1) Recommend aligning these dates in same column for easier reference
(2) Both cells nee same date format

Sum cell - =sum((B2-A1) +1) ~ Format this cell as NUMBER (0 decimal)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Count 2
Excel Formula - Count Dates from another Sheet 8
Help to create a macro 2
Counting Dates 2
Count specific days in between dates 2
Count until condition is met and then retain final count 2
counting dates using SUMPRODUCT 4
If cell is blank automatically enter today's date in the same cell 21

Back
Top