2013 Archives by date, by thread · List index

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

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)-(A5-1)+4
VLOOKUP(A1,\$A\$5:\$A\$375,1,1) finds the date you're looking for.
```
-(A5-1) subtracts the day before the first date on the list FROM the date found.
```     +4 adds in the four rows above the range.
The result is the row number of the date you're looking for.

I hope this helps.

-- Tim
===========================

On 9/13/2013 11:36 AM, IGraham wrote:
```
```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 position/row is dynamic either on the
Monday or above
This all works ok

However I then (for manipulating data by month) need to know the row/cell in
which the first day of the year (or month) appears
How do I look up/find within a column the cell in which the first day of the
month is - I assume that if I know how to do it for say January then I can
do it for any month.
I'm totally clueless as to how to do this

/Hopping that my explanation isn't to bamboozling/
```
```

-----
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context:
http://nabble.documentfoundation.org/Calk-lookup-cell-in-column-tp4074117.html
Sent from the Users mailing list archive at Nabble.com.

```
```

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
```

### Context

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.