| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to change date to reduce bal
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) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to change date to reduce bal
=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 "ern" wrote in message ... 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) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to change date to reduce bal
"Bernard Liengme" wrote: =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 "ern" wrote in message ... 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) 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to change date to reduce bal
Give some examples. Please be careful to specify DATE or DATA
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ern" wrote in message ... "Bernard Liengme" wrote: =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 "ern" wrote in message ... 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) 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does Excel change a date into a formula? | Excel Discussion (Misc queries) | |||
| Calculate date 28 days from now if hours reduce | Excel Worksheet Functions | |||
| How do i change the date formula | Setting up and Configuration of Excel | |||
| I need a formula that change all date by putting in one date | Excel Worksheet Functions | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
Linear Mode
