Formula Creation Display Text (SOLVED)

I've been assigned a task at work to create a formula on excel

Column Cell A Column Cell B
Work Date Commenced: Project Due:
10/09/2013
11/12/2008
11/03/2015
30/09/2010
23/07/2009
19/09/2008
26/08/2009


I need to devise a formula so that Column Cell B either displays "Project due" or "Project not yet due", a project is due exactly every 6 months from the work date commenced.

=IF((TODAY())-A1=6,"Project Due","Project not yet due")

This is all I have and I'm not sure if I'm on the right track or using the right formula. Creating a formula that describes if its been 6 months since their commencement date is what is getting to me.

Which formulae would be helpful in creating something to make a result show on excel every 6 months from that commencement date?

Try this formula

=IF(DATEDIF(A1,TODAY(),"m")=6,"Project Due","Project not yet due")

Analysis ToolPak add-in must be enabled for DATEDIF to work.

You also need to clarify what should happen if there are more than 6 months or less then 6 months

Hi, welcome to the forum

1st, Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(perhaps something like "display text when project due")

Also, take a look at =EDATE()

=IF(DATEDIF(A1,TODAY(),"m")>=6,"Project Due","Project not yet due")

thanks so much guys nearly getting it

Originally Posted by jumpingjack139

The formula worked out great and I'm alot closer to the solution, thank you so much.

When I experimented the formula for Cell A1 (10/09/13) by using a date (10/03/13), exactly 6 months before it showed Project Due, which was amazing. However when I tried a date (10/09/12), which is the next 6 month interval before that, it showed Project Not Due, which I guess is understandable because its no longer 6 months but 12 months which contradicts the formula. How would I tweak the formula so reacts to 6 month intervals rather than just the 6 months? I'm not particularly sure how to approach it further

=IF(DATEDIF(A1,TODAY(),"m")>=6,"Project Due","Project not yet due")

=IF(MOD(DATEDIF(A1,TODAY(),"m"),6)=0,"Project Due","Project not yet due")
TRY

you are welcome, thanks for your feedback and adding reputation

Originally Posted by AlKey

Analysis ToolPak add-in must be enabled for DATEDIF to work.

DATEDIF is a built-in function and the ATP is not needed for it to work.

http://www.cpearson.com/Excel/datedif.aspx

You're right Tony! I think I confused it with something else

Here's a list of all the ATP functions (near the bottom of the page):

https://support2.microsoft.com/defau...b;EN-US;291058

Of course, this only applies to Excel versions 2003 and earlier. These functions were added as built-in functions starting in Excel 2007.