| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to combine wordings in two columns | Excel Discussion (Misc queries) | |||
| Auto print | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| auto select cells to print | Excel Worksheet Functions | |||
| How do I auto increment cell value on print in Excel | Excel Worksheet Functions | |||
Linear Mode
