<div>
Assuming the date column is column 'A' and the data starts in row 2, and assuming that &nbsp;new rows (and existing rows) will have something in column 'B' then put this in A2 and copy all the way down (or for enough rows to enclose all possible potential new rows).<br />
<br />
=IF(B2=&quot;&quot;,&quot;&quot;,TODAY())
</div>


<div>
I keep getting April 43, 2038. Actually, 44338
</div>


<div>
The column needs to be formatted as a date, but I just realized that my formula isn't any good since all the dates will be updated every day.
</div>


<div>
You can manually put a frozen date in a cell by pressing Ctrl+;
</div>


<div>
Or if you don't mind VBA, put this in the sheet's Change event.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-43292112-1"><span>Private Sub Worksheet_Change(ByVal Target As Range)</span>
<span>    Dim dteNow As Date</span>
<span>    If Not Intersect(Target, Range(&quot;B:B&quot;)) Is Nothing Then</span>
<span>        If Not IsEmpty(Target) Then</span>
<span>            dteNow = Format(Now, &quot;mm/dd/yyyy&quot;)</span>
<span>            Target.Offset(0, -1) = dteNow</span>
<span>        End If</span>
<span>    End If</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
Where is the change event?<br><br>This is rather ironic project?<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561785/Cov-XL.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w21/1561785/Cov-XL.png" class="fr-fic fr-dib" style="width: 703px;"></a>
</div>


Cov-XL.png

29216526.xlsm

Bert2005

<div>
I’m glad I was able to help.<br />
<br />
If you expand the “Full Biography&quot; section of <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you’ll find links to some articles I’ve written that may interest you.<br />
<br />
Marty - Microsoft MVP 2009 to 2017<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Most Valuable Expert (MVE) 2015, 2017<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Distinguished Expert in Excel 2018<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Top Expert Visual Basic Classic 2012 to 2020<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Top Expert VBA 2018 to 2020
</div>


<div>
<div class="content wysiwyg-content fr-view">
Excel v2104 in O365 opened in app. I read a lot about how to make the current date change, but not the date in a new row. Or is that what it means? The new row would automatically start with today's date?
</div>
</div>



Excel v2104 in O365 opened in app. I read a lot about how to make the current date change, but not the date in a new row. Or is that what it means? The new row would automatically start with today's date?

Trying to make Excel v2104 put in today's date with each new row

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.