Saturday, November 26, 2011

yogi_Extract Data For Repetitive Entities By Latest Date

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user jamiewig said:
Query on date cleaned
I have a list of window cleaning jobs and need to run a query on the  the last time each one was cleaned (date) and then  work out the next clean date which would be 4 weeks from that date. can any one help
-----------------------------------------------------

see the following for solution to the problem ...