| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today function is driving me nuts
Hi folks,
I am trying to do something really simple. Cell A4 has an expiry date, Cell B4 has a formula which should give a renew message if the expiry date is within 30 days of todays date....except it doesn't. Remove Today() and it works. aaaaarrrrgh! The formula is =if(today()-30<=a4,"renew","") Any help much appreciated Danny |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today function is driving me nuts
=IF(A4+30=TODAY(),"Renew","")
-- HTH RP (remove nothere from the email address if mailing direct) "Danny J" wrote in message ... Hi folks, I am trying to do something really simple. Cell A4 has an expiry date, Cell B4 has a formula which should give a renew message if the expiry date is within 30 days of todays date....except it doesn't. Remove Today() and it works. aaaaarrrrgh! The formula is =if(today()-30<=a4,"renew","") Any help much appreciated Danny |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Evaluating Today() function only once in a worksheet | Excel Worksheet Functions | |||
| How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Linear Mode
