<div>
set a custom format of dddd on the cell to see just the day...
</div>


set a custom format of dddd on the cell to see just the day...

<div>
<div class="content wysiwyg-content">
What formula do I enter in order to calculate the first day of that year, given any date?<br />
<br />
For example, if I reference today's date (11/8/11) in the formula, it should return 01/01/11.<br />
If I enter 5/5/2010, it should return 01/01/10, and so forth.<br />
<br />
Thanks in advance!
</div>
</div>


What formula do I enter in order to calculate the first day of that year, given any date?

For example, if I reference today's date (11/8/11) in the formula, it should return 01/01/11.
If I enter 5/5/2010, it should return 01/01/10, and so forth.

Thanks in advance!

Excel Formula for calculating the first day of any given 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.