eg
Cell E2= 07/09/13, how could i get it to display in red "call now" in cell F2 2months and 10 days later
Any help appreciated
eg
Cell E2= 07/09/13, how could i get it to display in red "call now" in cell F2 2months and 10 days later
Any help appreciated
Try this regular formula:
=EDATE(E2;2)+10
Does that work for you?
F2 = eomonth(a16;2)+10
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi, try
=IF(DATE(YEAR(E2),MONTH(E2)+2,DAY(E2)+10)<=TODAY(),"call now","")
To get it to display the text in red, you could just format the cells to red text, since they are either blank or should be red? Or you could use conditional formatting.
formula in f2
=IF(TODAY()>=EDATE(E2,2)+10,"CALL NOW","")
conditional format cell as
cell value equal to
="call now" choose red font
Last edited by martindwilson; 09-07-2013 at 10:38 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
just get an error with formula msg
Hi, my previous suggestion was a bit clumsy :-)
With Ron's solution:
=IF(EDATE(E2,2)+10<=TODAY(),"call now","")
Martin Wilson
This gets the dates correct but only displays a red box with no text, close though
well you must be doing something wrong! see attached
@pedkerr.
You get several answers from several members, in that case you can better add to whom your replying.
Please post you example, with the given solutions, which don't work.
well id have thought its obvious as only 2 people have referred to using cf to get the red "call now" as i the op original question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks