Automatically updating insertion of first and last day of year
 

I use a drop-down list for choosing between a calendar and fiscal year; if I
select "Calendar" in cell A1, what would be a formula for inserting the first
day of the year (in cell B1) and last day in the year (in cell B2) that would
update each year without having to manually enter the dates 1/1/09 and
12/31/09 in the formula, as shown below:

The formula I have now is:
(For Cell B1) =IF(A1="Calendar","1/1/2009")

--
MZ

Automatically updating insertion of first and last day of year
 

=IF(A1="Calendar","01/01/" & YEAR(TODAY()),"Value if not Calendar")

"MZ" wrote:

I use a drop-down list for choosing between a calendar and fiscal year; if I
select "Calendar" in cell A1, what would be a formula for inserting the first
day of the year (in cell B1) and last day in the year (in cell B2) that would
update each year without having to manually enter the dates 1/1/09 and
12/31/09 in the formula, as shown below:

The formula I have now is:
(For Cell B1) =IF(A1="Calendar","1/1/2009")

--
MZ