can excel print wordings auto ?
 

For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date due
is up" automatically. Then after 1 week or few days ( 3 or 5), that message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

Can i take the reply as "NO" since no 1 feedback?

"kyoshirou" wrote:

For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date due
is up" automatically. Then after 1 week or few days ( 3 or 5), that message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

--
Regards
Roger Govier

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

To cope more closely with varying lengths of months, Roger's formula could
perhaps be modified along the lines of:
=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

Hi David
That is better.

--
Regards
Roger Govier

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
To cope more closely with varying lengths of months, Roger's formula could
perhaps be modified along the lines of:
=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

Hi David & Roger,

Thanks!

"David Biddulph" wrote:

To cope more closely with varying lengths of months, Roger's formula could
perhaps be modified along the lines of:
=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))

Would u mind explain what does it term means?
I dont know.



"David Biddulph" wrote:

To cope more closely with varying lengths of months, Roger's formula could
perhaps be modified along the lines of:
=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

For some unknown reason, DATEDIF is the one Excel function not covered
currently by Excel Help.
For details of the function, see http://www.cpearson.com/excel/datedif.aspx
--
David Biddulph

"kyoshirou" wrote in message
...
=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))

Would u mind explain what does it term means?
I dont know.



"David Biddulph" wrote:

To cope more closely with varying lengths of months, Roger's formula
could
perhaps be modified along the lines of:
=IF(TODAY()<B1,"",IF(AND(MOD(DATEDIF(B1,TODAY(),"m "),3)=0,DATEDIF(B1,TODAY(),"md")<=5),"DUE
DATE",""))
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like:
date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again
auto?


Thanks!

can excel print wordings auto ?
 

=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")
what does that =0 and <=5 means?



"Roger Govier" wrote:

Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

--
Regards
Roger Govier

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like: date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again auto?


Thanks!

can excel print wordings auto ?
 

Hi

The MOD() function is dividing the number of days between Today() and your
date in B1, by 91 (approximate number of days in 3 months) and returning the
remainder.

The =0 and <= 5 is comparing this values and if it is equal to or more than
0, and les than or equal to 5, then show DUE Date, otherwise show nothing.

The response from David using Datedif gives an exact result.

--
Regards
Roger Govier

"kyoshirou" wrote in message
...
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")
what does that =0 and <=5 means?



"Roger Govier" wrote:

Hi

This not exact, but probably close enough for your requirement
=IF(AND(MOD(TODAY()-B1,91)=0,MOD(TODAY()-B1,91)<=5),"DUE DATE","")

--
Regards
Roger Govier

"kyoshirou" wrote in message
...
For example, if i have a date field of 28/02/08 in column B,
can i configure in column C such that every 3 months, message like:
date
due
is up" automatically. Then after 1 week or few days ( 3 or 5), that
message
will auto-erase.
And after 3 months, the message "date due is up" will output again
auto?


Thanks!