Clueless... cleaning schedule spreadsheet

[jadeewy]

I have a list of over 100 buildings. I need to keep track of window cleaning. Each building is cleaned internally and externally once a year and just externally twice a year. I would like to make a way to see which buildings are due for cleaning. Completely clueless, help!!

 

[jmacleary]

I'm not sure excel is the best application to use for this - why not try a calendaring application?

 

[jadeewy]

I'm not sure excel is the best application to use for this - why not try a calendaring application?

Hi, thanks for your reply. My manager is asking for a database which I can save for the team to use so I'm really unsure of how to do this

 

[Logit]

.
Here is one method.

Download link : https://www.amazon.com/clouddrive/share/02cBM58Eaml34jHGP3WLGaIRFWkvrL2NIII2FRQ3zTX

Some of the code :

=IF(AND(C2="",B2=""),"-",B2&"_"&COUNTIF(B$2:B2,B2))

=IF(ISNA(MATCH(D2&"_"&$A3,Events!$A:$A,0)),"",INDEX(Events!$C:$C,MATCH(D2&"_"&$A3,Events!$A:$A,0)))

 

[Logit]

.
You are welcome. Trust the suggestions worked for you.

Glad to help.