<div>
You are very welcome, johndarby!
</div>


<div>
<div class="content wysiwyg-content">
Greetings,<br />
I have a two columns of dates<br />
1. column 1 has the date a file goes to the press to print<br />
2. column 2 has the date the file prints<br />
<br />
In column two, the date is almost always the same as the date in column 1, except if the date in column 1 is a weekend date (Saturday, Sunday)<br />
<br />
Is there a phase (formula) which would be suitable to put in column2, with the above parameters?<br />
<br />
Thank you,<br />
JohnD
</div>
</div>


Greetings,
I have a two columns of dates
1. column 1 has the date a file goes to the press to print
2. column 2 has the date the file prints

In column two, the date is almost always the same as the date in column 1, except if the date in column 1 is a weekend date (Saturday, Sunday)

Is there a phase (formula) which would be suitable to put in column2, with the above parameters?

Thank you,
JohnD

Excel formula to output date

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