Oct 16 2020 02:55 AM
Hi can someone please tell me how to a formula that will subtract cells from a starting number as opposed to the values in the cell
Oct 16 2020 03:59 AM
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture.
Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
You could get a precise solution much faster with a file (w/out sensitive data).
This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Oct 16 2020 04:02 AM
Oct 16 2020 04:04 AM
@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
Oct 16 2020 04:26 AM - edited Oct 16 2020 04:27 AM
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.
Oct 16 2020 04:34 AM
@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
Oct 16 2020 07:37 AM
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.