My daughter is class librarian - she has todays date on sheet and day book issued - this gives her a 'days out' column - is there any way that formula can be cancelled when the book is returned? =$J$25-L28 (probably a simple change)
Today 21/10/2014
Book Out_____ Returned Days O/S
A1 10/10/2014 (BLANK)_____11
A2 09/10/2014 15/10/2014 12
So she's wanting the 12 to show as 'Returned'
Thanks
Bookmarks