Euro5

<div>
<div class="content wysiwyg-content fr-view">
I would like a formula that would read data in I2 and return whether this date is last month or this month, using<br>LAST CURRENT<br>So if 3/1/2021 the formula would return LAST<br>4/12/2021 would return CURRENT<br><br>Can anyone help? Thank you!
</div>
</div>



I would like a formula that would read data in I2 and return whether this date is last month or this month, using
LAST CURRENT
So if 3/1/2021 the formula would return LAST
4/12/2021 would return CURRENT
Can anyone help? Thank you!

excel formula if date is last month or this month

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.