Trying to use functions

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I am trying to create a function and I am having
problems. I want to have like a countdown type of
function. I want to have todays date add a day until it
hits 30 days and the function stops. Is there a way to do
this? If you are confused please ask questions and I will
try to explain myself more clearly :)
 
I'll start the question asking-

1. what is your intention?

2. does it add a day every DAY until it gets to 30?

functions normally do things more or less instantly.
 
in cell a1 =TODAY()


in cell b1 12/31/2003 (whatever your target date is)


in cell c1 =IF(DAYS360(A1,B1)>30,DAYS360(A1,B1),30)

if you want to hide the target date, in the above formula
(cell c1), change the B1 to your target date.


have fun... BTW - better be an invite for NIU!!
 
My intention is to have the worksheet countdown each day I
enter it. I want to have the cell post the number of days
I have left to do something counting down from 30.
 
Sorry the solution that I posted worked it the other way,
kinda. Why can't you just take today's date and subtract
your target date? This will give you the number of days
left till your dealine.

in cell a1 =TODAY()


in cell b1 12/31/2003 (whatever your target date is)


in cell c1 =DAYS360(A1,B1)

if you want to hide the target date, in the above formula
(cell b1), change the B1 to your target date

if you want to hide todays date, in the above formula
(cell b1), change b1 (today())
 
Because you want it to count down from 30 specifically and "end" when 30
days are over--

If you want to show a blank when there is either >30 days left, or the date
has passed you can use

=+IF(OR(A1-TODAY()>30,A1-TODAY()<0),"",A1-TODAY())

This is if the target date is in A1 and you don't mind showing negative
numbers (when the date has passed)

=+IF(A1-TODAY()>30,"",A1-TODAY())
 
I think i guessed right with my shot at it, however if the dates are not
placed in another cell, the formula will have to be changed if you want to
manually insert the 'target date' right in the formula (but I would guess
you don't need that).
 
yeah! that worked, thank you so much.
-----Original Message-----
Because you want it to count down from 30 specifically and "end" when 30
days are over--

If you want to show a blank when there is either >30 days left, or the date
has passed you can use

=+IF(OR(A1-TODAY()>30,A1-TODAY()<0),"",A1-TODAY())

This is if the target date is in A1 and you don't mind showing negative
numbers (when the date has passed)

=+IF(A1-TODAY()>30,"",A1-TODAY())







.
Click to expand...
 
Back
Top