Days left until...

J

Jay Gustafson

Hello,

I have two columns. One column indicates the due date. The other will show how many days are left until the due today.

Cell A2 = 07/19/05

Cell B2 = 365

If cell A2 has no value, then I want cell B2 to look empty even though there is a formula sitting in it.

If cell B2 shows there are no more days left, or it starts showing minus, I want it to say "Past" indicating there are no days left.

I would appreciate any help with this. Thank you

Jay
 
F

Frank Kabel

Hi
try
=IF(A2="","",A2-TODAY())
and format this cell as 'Number'

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag Hello,

I have two columns. One column indicates the due date. The other will
show how many days are left until the due today.

Cell A2 = 07/19/05

Cell B2 = 365

If cell A2 has no value, then I want cell B2 to look empty even though
there is a formula sitting in it.

If cell B2 shows there are no more days left, or it starts showing
minus, I want it to say "Past" indicating there are no days left.

I would appreciate any help with this. Thank you

Jay
 
P

Peo Sjoblom

=IF(A2="","",IF(TODAY()>=A2,"Past Due",A2-TODAY()))

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


Hello,

I have two columns. One column indicates the due date. The other will show
how many days are left until the due today.

Cell A2 = 07/19/05

Cell B2 = 365

If cell A2 has no value, then I want cell B2 to look empty even though there
is a formula sitting in it.

If cell B2 shows there are no more days left, or it starts showing minus, I
want it to say "Past" indicating there are no days left.

I would appreciate any help with this. Thank you

Jay
 

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

Difference Between Dates WITH Conditional Formatting 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Difference between two date/time values 5
Using Three Conditions in CF 3
No of Days between two dates and offset formula 4
Calculation of working days between two dates 1
if "x" days is more fall on weekend return following monday 3
calculating a formula for a service level 6

Top