Re: [libreoffice-users] Calk - lookup cell in column

2013-09-14 Thread Jim Trigg
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

Re: [libreoffice-users] Calk - lookup cell in column

2013-09-14 Thread Tim Deaton
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)

Re: [libreoffice-users] Calk - lookup cell in column

2013-09-13 Thread Brian Barker
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

[libreoffice-users] Calk - lookup cell in column

2013-09-13 Thread IGraham
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