I would make a new column next to the "photo last updated" column with the formula "=TODAY()-(
photo last updated column)", and make sure it's formatted as a number. That will give you how many days have passed since that date as an integer.
Then, it's easy to use countif/countifs to get what you're looking for:
- (number of new photos)=COUNTIF((column of days passed since last photo update),"<180")
- (number of medium photos)=COUNTIFS((column of days passed since last photo update),">=180",(column of days passed since last photo update),"<=365")
- (number of old or missing photos)=COUNTIF((column of days passed since last photo update),">365")+COUNTBLANK(column of days passed since last photo update)
You do have to watch out that the column referenced by the COUNTBLANK function is the same size as the full data set column, or your count will be too high.
EDIT: I'm not sure if I understood about the Location ID part of your question, but you can filter those by making them all COUNTIFS functions and adding another criteria and criteria range to the formula for the specific Location ID.