ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   countdown (https://www.excelbanter.com/excel-discussion-misc-queries/249442-countdown.html)

puiuluipui
countdown
 
Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

Jacob Skaria
countdown
 
In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

puiuluipui
countdown
 
It's working!
Thanks allot!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

puiuluipui
countdown
 
I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

Jacob Skaria
countdown
 
Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

puiuluipui
countdown
 
Thanks allot!!!!!!

"Jacob Skaria" a scris:

Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

David Biddulph[_2_]
countdown
 
=IF(ISTEXT(A1),A1,IF(A1<TODAY(),"Please pay",A1-TODAY()))
--
David Biddulph

"puiuluipui" wrote in message
...
I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to
display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!



puiuluipui
countdown
 
Hi Jacob, i have a minor problem. In A1 i will have : "Final rate" ,
"Integral" and a date.

I need this code to display a message for "Final rate" and another message
for "Integral". If the code finds a date, then to calculate countdown.
Ex:
Final rate = Final
Integral = Full
Can this be done?
Thanks allot Jacob!

"Jacob Skaria" a scris:

Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

Jacob Skaria
countdown
 
(all in one line)

=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),
IF(A1="Final rate","Final",IF(A1="Integral","Full","")))

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi Jacob, i have a minor problem. In A1 i will have : "Final rate" ,
"Integral" and a date.

I need this code to display a message for "Final rate" and another message
for "Integral". If the code finds a date, then to calculate countdown.
Ex:
Final rate = Final
Integral = Full
Can this be done?
Thanks allot Jacob!

"Jacob Skaria" a scris:

Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

puiuluipui
countdown
 
I's working great!!
Thanks!

"Jacob Skaria" a scris:

(all in one line)

=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),
IF(A1="Final rate","Final",IF(A1="Integral","Full","")))

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi Jacob, i have a minor problem. In A1 i will have : "Final rate" ,
"Integral" and a date.

I need this code to display a message for "Final rate" and another message
for "Integral". If the code finds a date, then to calculate countdown.
Ex:
Final rate = Final
Integral = Full
Can this be done?
Thanks allot Jacob!

"Jacob Skaria" a scris:

Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!


All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com