Forum Discussion
Need help please
NikolinoDE See enclosed.
I want the 21 at the top to reduce each time I put a date in that vertical column. so the bottom cell will reduce i.e. days left, 20, 19, 18, 17 etc. But when I do the normal subtract formula it is using the date (ie holiday time) as a value
You were finding problem because all the cells in B2:S23 formatted as TEXT,,, now check the sheet I've first applied GENERAL format then the Formula, and filled across the Range.
Check B27:S34 also.
**Please mark my post as Best solution as well like, if it solves the issue.
Rajesh_Sinha unfortunately thats not what i mean. If you look at the spreadsheet now I have entered a couple of dates in as if the individual booked these off and I want the figure at the bottom to automatically deduct each date itself. i.e. if I now enter 04.01.20 then the figure at the bottom would reduce by one again
Here is an example file with a very simple formula.
If TEXT is in given cells then subtract.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
