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/ Any ideas - please ----- 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