excel logbooks
i'm sure someone can answer this simple one (but not simple for me)
i have created an excel database logbook but carnt work out an equasion to add up how many hours done in the last 28/90/365 days.
The database is the same as the paper format ie colums go date (day/month/year),reg,destination ,etc, dep time,arrival time, P1 time single day, P1 time single night et etc
What calculation do i need to check the first column to find any date between today and 28 days previous - if the date falls in that range then to add up the time in the column for P1 time etc (if that makes sense !)
or if there is an excel guru out there i can forward the file to get it sorted !
thanks in advance