Need help please

%3CLINGO-SUB%20id%3D%22lingo-sub-1787462%22%20slang%3D%22en-US%22%3ENeed%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787462%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20can%20someone%20please%20tell%20me%20how%20to%20a%20formula%20that%20will%20subtract%20cells%20from%20a%20starting%20number%20as%20opposed%20to%20the%20values%20in%20the%20cell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1787462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787709%22%20slang%3D%22de-DE%22%3ESubject%3A%20Need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787709%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834850%22%20target%3D%22_blank%22%3E%40christinemurray%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%3C%2FP%3E%3CP%3EEven%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3EYou%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%3C%2FP%3E%3CP%3EThis%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787716%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787716%22%20slang%3D%22en-US%22%3EFor%20better%20understanding%20please%20share%20some%20Sample%20data%20along%20with%20expected%20result!!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787718%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787718%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%20See%20enclosed.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20want%20the%2021%20at%20the%20top%20to%20reduce%20each%20time%20I%20put%20a%20date%20in%20that%20vertical%20column.%20so%20the%20bottom%20cell%20will%20reduce%20i.e.%20days%20left%2C%2020%2C%2019%2C%2018%2C%2017%20etc.%20But%20when%20I%20do%20the%20normal%20subtract%20formula%20it%20is%20using%20the%20date%20(ie%20holiday%20time)%20as%20a%20value%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787760%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787760%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20were%20finding%20problem%20because%20all%20the%20cells%20in%20B2%3AS23%20formatted%20as%20TEXT%2C%2C%2C%20now%20check%20the%20sheet%20I've%20first%20applied%20GENERAL%20format%20then%20the%20Formula%2C%20and%20filled%20across%20the%20Range.%3CBR%20%2F%3ECheck%20B27%3AS34%20also.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E**%3CFONT%20size%3D%222%22%20color%3D%22%230000FF%22%3EPlease%20mark%20my%20post%20as%26nbsp%3B%20Best%20solution%20as%20well%20like%2C%20if%20it%20solves%20the%20issue.%26nbsp%3B%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787799%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3Bunfortunately%20thats%20not%20what%20i%20mean.%20If%20you%20look%20at%20the%20spreadsheet%20now%20I%20have%20entered%20a%20couple%20of%20dates%20in%20as%20if%20the%20individual%20booked%20these%20off%20and%20I%20want%20the%20figure%20at%20the%20bottom%20to%20automatically%20deduct%20each%20date%20itself.%20i.e.%20if%20I%20now%20enter%2004.01.20%20then%20the%20figure%20at%20the%20bottom%20would%20reduce%20by%20one%20again%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

6 Replies

@christinemurray 

 

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)

For better understanding please share some Sample data along with expected result!!

@Nikolino  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-S 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 

@christinemurray 

 

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.