Hi all,
New here and self taught but looking for information on my spreadsheet i am creating. I am currently in charge of my works annual leave and have made a rota for all to use. I have formulas for dates etc and have everything set up....
The one thing I'm stuck with is when i roll the date forward how do i get the information i already input for the old dates to disappear....
For example 3/11/17 will have say me working...when i change the date say forward it will change the date but the "me"working is still there?
i get i probably have not explained very well, but if you understand me id really appreciate the help.
maNY HANKS
Bookmarks