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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Summation in Excel 0
Excel ignore formula 8
Excel formula, sum the value cell and if empty cell left blank 0
IF(AND 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
sum of multiple conditional funtions....??? 5
Year + week => first date of week 9
Building closed workbook file path within an Index Function 6

Back
Top