Realtor, BRE #: 02096503

David Bigelow

<div>
Hi byundt,<br />
Thank you for your help. The first formula is exactly what I needed.
</div>


Hi byundt,
Thank you for your help. The first formula is exactly what I needed.

<div>
<div class="content wysiwyg-content">
For Excel, what is a formula for calculating the 25th day of the month, or the weekday before the 25th if it falls on a weekend day? I'll be using a date reference cell of H4.
</div>
</div>


For Excel, what is a formula for calculating the 25th day of the month, or the weekday before the 25th if it falls on a weekend day? I'll be using a date reference cell of H4.

How to calculate the nth day of the month, or the preceeding weekday if nth day is on weekend.

datetime

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.