Thanks very much, your help is very appreciated. I seem to have learned lots from this forum in the short time I have been a member. Thank you to ev...
Further to my last post, when inserting new rows, this formula doesn't seem to work, something not right here..
Velouria said Where do you get 5 from? Only the first 5 rows have a due date less than or equal to 29-May-20 and the actual completion date in row 22...
Thanks guys, what I am trying to do is count the instances where an event is completed on the due date or before it, so checking if the task was compl...
Anders, That worked perfectly. Thank you so much, very much appreciated.
Anders, Thanks for that. I did try using the + but for some strange reason, it didn't work. It is working now though so thank you for that. I ...
Thanks for your reply. I have hopefully attached a sample file here : As you will see, I have an orange highlight for dates next month but ...