title: Excel Formula which places date/time in cell when data is entered in another cell in the same row
body: <p>Hoping there is a way this can be done with a formula since I will be putting this on SharePoint as a shared workbook.  </p>
  
  <p>Column B contains Tasks, while Column E contains the Date and Time of when the Task was assigned.  Is there a formula that would automatically enter the current date and time in Column E whenever someone entered data into column B?</p>
  
  <p>Any assistance would be greatly appreciated.</p>