| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up countdown timer to countdown days to a specific day | Excel Worksheet Functions | |||
| Countdown | Excel Discussion (Misc queries) | |||
| Countdown | Excel Worksheet Functions | |||
| Countdown | Excel Worksheet Functions | |||
| Countdown | Excel Worksheet Functions | |||
Linear Mode
