<div>
Thank you Rainer for such a quick turnaround. &nbsp;The formula did exactly what I needed
</div>


Thank you Rainer for such a quick turnaround.  The formula did exactly what I needed

<div>
<div class="content wysiwyg-content">
I need to know exactly have to write this statement in SharePoint<br />
Background. &nbsp;I need 2 separate columns to populate dates if another column is NOT blank<br />
<br />
for the MM Start column, I need it to populate a certain date based on [A2] not blank<br />
MM Start Column<br />
If [New MM ID] is not blank and [Comments]=&quot;add&quot;, then &quot;4/27/2015&quot;<br />
If [New MM ID] is not blank and [Comments] = &quot;remove&quot;, then &quot;&nbsp;&quot;<br />
<br />
MM End column<br />
If [New MM ID] is not blank and [Comments]=&quot;add&quot;, then &quot;12/31/9999&quot;<br />
If [New MM ID] is not blank and [Comments] = &quot;remove&quot;, then &quot;4/27/2015&quot;<br />
If New is blank, I need for MM Start and MM End to stay blank<br />
<br />
<br />
results<br />
New MM ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Comments &nbsp; &nbsp; &nbsp; MM Start &nbsp; &nbsp; &nbsp; MM End<br />
test &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; add &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4/27/2015 &nbsp; &nbsp; 12/31/9999<br />
test &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; remove &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4/27/2015
</div>
</div>


I need to know exactly have to write this statement in SharePoint
Background.  I need 2 separate columns to populate dates if another column is NOT blank

for the MM Start column, I need it to populate a certain date based on [A2] not blank
MM Start Column
If [New MM ID] is not blank and [Comments]="add", then "4/27/2015"
If [New MM ID] is not blank and [Comments] = "remove", then " "

MM End column
If [New MM ID] is not blank and [Comments]="add", then "12/31/9999"
If [New MM ID] is not blank and [Comments] = "remove", then "4/27/2015"
If New is blank, I need for MM Start and MM End to stay blank


results
New MM ID               Comments       MM Start       MM End
test                               add                    4/27/2015     12/31/9999
test                               remove                                      4/27/2015

If then statement in SharePoint 2010

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.