Formula to change date to reduce bal

E

ern

What formula can i enter a date in a cell (say b2) and reduce bal of 200 in
cell J2 by any amount (IE-20)
 
B

Bernard Liengme

=J2-20
or =J2-J1 with the amount to subtract in J1 (or elsewhere)
best wishes
 
E

ern

Bernard Liengme said:
=J2-20
or =J2-J1 with the amount to subtract in J1 (or elsewhere)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email



I think i asked the question wrong I want to put date in say cell b2 and i want it to deduct a fixed amount from the total in cell j2
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula 6
Source and Destination worksheet difference 5
Set date minuse 1 working day 3
pulling values from column g into a variable, and returning variableon spreadsheet 3
Finding Used time for Payroll 1
Help with String Field 15
Can I use a UDF in an array formula? 2
So easy I Think 2

Top