<div>
Try:<br />
<br />
=YEAR(TODAY())-1<br />
<br />
EDITED for placement of brackets.
</div>


Try:

=YEAR(TODAY())-1

EDITED for placement of brackets.

<div>
Rob, did you mean:<br />
<br />
<b>=YEAR(TODAY())-1</b><br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Rob, did you mean:

=YEAR(TODAY())-1



----------------------------------------

»bp

<div>
@Bill, - yes and edited; comments passed each other in the ether.
</div>


@Bill, - yes and edited; comments passed each other in the ether.

checkmark-128-1-.pnghttps://filedb.experts-exchange.com/incoming/2020/01_w04/1441420/checkmark-128-1-.png

checkmark-128-1-.png

<div>
@stephen - in case you need it explaining:<br />
<br />
TODAY() gives today's date (as per system of PC)<br />
YEAR(Date) &nbsp;will extract the year element of the given date, in this case TODAY()<br />
YEAR(Date)-1 will subtract 1 from year result.
</div>


@stephen - in case you need it explaining:

TODAY() gives today's date (as per system of PC)
YEAR(Date)  will extract the year element of the given date, in this case TODAY()
YEAR(Date)-1 will subtract 1 from year result.

<div>
When I copy and paste the above, it just displays =YEAR(TODAY())-1<br />
but not 2019<br />
<br />
can ya'll put that in &nbsp;CODE BRACKETS???
</div>


When I copy and paste the above, it just displays =YEAR(TODAY())-1
but not 2019

can ya'll put that in  CODE BRACKETS???

stephenlecomptejr

<div>
Sometimes paste into Notepad first
</div>


<div>
Welcome.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Welcome.



----------------------------------------

»bp

<div>
<div class="content wysiwyg-content">
Need proper Excel formula to display previous current year. &nbsp;As an example - this current year is 2020 - I need it to show 2019.<br />
I keep trying various =TODAY( syntaxes but they all fail.)<br />
<br />
And the searches take me on a long journey I have no time to drive!
</div>
</div>


Need proper Excel formula to display previous current year.  As an example - this current year is 2020 - I need it to show 2019.
I keep trying various =TODAY( syntaxes but they all fail.)

And the searches take me on a long journey I have no time to drive!

Need proper Excel formula to display previous current year.

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.