Calculating 2 months and 10 days from a specific date

1. Calculating 2 months and 10 days from a specific date

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

2. Re: Calculating 2 months and 10 days from a specific date

Try this regular formula:
=EDATE(E2;2)+10

Does that work for you?

3. Re: Calculating 2 months and 10 days from a specific date

F2 = eomonth(a16;2)+10

4. Re: Calculating 2 months and 10 days from a specific date

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.

5. Re: Calculating 2 months and 10 days from a specific date

formula in f2
=IF(TODAY()>=EDATE(E2,2)+10,"CALL NOW","")
conditional format cell as
cell value equal to
="call now" choose red font

6. Re: Calculating 2 months and 10 days from a specific date

just get an error with formula msg

7. Re: Calculating 2 months and 10 days from a specific date

Hi, my previous suggestion was a bit clumsy :-)
With Ron's solution:

=IF(EDATE(E2,2)+10<=TODAY(),"call now","")

8. Re: Calculating 2 months and 10 days from a specific date

Martin Wilson

This gets the dates correct but only displays a red box with no text, close though

9. Re: Calculating 2 months and 10 days from a specific date

No, afraid this doesn't work

Originally Posted by estige
Hi, my previous suggestion was a bit clumsy :-)
With Ron's solution:

=IF(EDATE(E2,2)+10<=TODAY(),"call now","")

10. Re: Calculating 2 months and 10 days from a specific date

well you must be doing something wrong! see attached

11. Re: Calculating 2 months and 10 days from a specific date

@pedkerr.

Please post you example, with the given solutions, which don't work.

12. Re: Calculating 2 months and 10 days from a specific date

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)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1