Formula to change date to reduce bal

  • Thread starter Thread starter ern
  • Start date Start date
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)
 
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...
 
Back
Top