On 09/14/2013 07:01 PM, Tim Deaton wrote:
The closest I came to a solution was a scenario where all the dates
for the year were in one column.
I put the dates for the year (Monday 12/31/2012 thru Sunday 1/5/2014
in A5:A375.
Then, in A1 I put whatever date I'm looking for.
Off to the side (D1
The closest I came to a solution was a scenario where all the dates for
the year were in one column.
I put the dates for the year (Monday 12/31/2012 thru Sunday 1/5/2014 in
A5:A375.
Then, in A1 I put whatever date I'm looking for.
Off to the side (D1) I entered: =VLOOKUP($A$1,$A$5:$A$375,1,0)
At 08:36 13/09/2013 -0700, Graham Lovatt wrote:
Calk - lookup cell in column
I imagine it's your spelling checker that thinks Calc is called Calk?
I have a spreadsheet that records data for each day of the year.
Vertically row by row I have the days of the year. I like my week to
start on a
Hi
Now this might take a bit of explaining
I have a spreadsheet that records data for each day of the year
Vertically row by row I have the days of the year
I like my week to start on a Monday
So I have my year/days set to start on the first Monday of the year
So the actual first day of the year