Formula help

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

Patrick C. Simonds

In cell A2 I input a year (2008, 2009 ect) in cell A11 I need a formula
which will return a value which represents the first day of January of the
year displayed in cell A2.
 
In cell A2 I input a year (2008, 2009 ect) in cell A11 I need a formula
which will return a value which represents the first day of January of the
year displayed in cell A2.
Click to expand...

=date(a2,1,1)


--ron
 
The parentheses and double minus sign are required...

=--("1/1/"&A2)

Rick
 
Back
Top