PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Misc > countdown

Reply
Thread Tools Rate Thread

countdown

 
 
puiuluipui
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
puiuluipui
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
puiuluipui
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
Jacob Skaria
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
puiuluipui
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      26th Nov 2009
=IF(ISTEXT(A1),A1,IF(A1<TODAY(),"Please pay",A1-TODAY()))
--
David Biddulph

"puiuluipui" <(E-Mail Removed)> wrote in message
news:C29EF62F-C01B-4362-B378-(E-Mail Removed)...
>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!
 
Reply With Quote
 
puiuluipui
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
Jacob Skaria
Guest
Posts: n/a
 
      26th Nov 2009
(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!
 
Reply With Quote
 
puiuluipui
Guest
Posts: n/a
 
      26th Nov 2009
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!
 
Reply With Quote
 
 
 
Reply

« Converting 123 CR & 4567 DB to 123 & -4567 | Import more than one .csv file into the same Excel file. »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set up countdown timer to countdown days to a specific day Jenny Microsoft Excel Worksheet Functions 2 28th Jun 2009 04:42 PM
Countdown simserob Microsoft Excel Worksheet Functions 5 22nd Jul 2006 02:40 AM
Countdown simserob Microsoft Excel Worksheet Functions 0 21st Jul 2006 06:26 PM
60 second countdown =?Utf-8?B?c3RldmVubWF1cnk=?= Windows XP Hardware 16 27th Jun 2005 03:01 PM
COUNTDOWN Bruce Stokes Windows XP General 2 15th Sep 2004 02:59 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 04:39 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top