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!
|