Search results

thanks for the reply that works great the countif command, is there an opposite that reduces the number also?? when you enter data.

thanks for the reply i have attached the sheet hope this help you out any as iam not sure what you meant by your formula.

good evening i have a spread sheet for holidays and i want to have a starting total of holidays in a cell lets say 30 days. then below this number i have made a sheet with the 12months on it with the days of the week. what i want to do is enter an X in a cell and have the number 30...

formatting cells thanks for yor reply i have attached a zip file copied into word but i have it saved in excel, i want the holiday entitlement to reduce every time a holiday is entered on the spread sheet . i have left an example on the sheet with six days aloccated just wondering how you add...

good evening iam after alittle help. i have made a holiday planner for work, where you input an X for a holiday and the cell turns red. what i need to do it make another box outside the sheet with total amount of days allocated for leave and when an X is entered say for April the 5th to...

HI is there an easy dowload that i can get hold of so that i can monitor annual leave by just entering names and days on leave, nothing to involving i have tried to make my own getting tips online but to no joy. thanks for any help in advance.