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?
Bookmarks