I want to put a date in a cell (I.E. a2) and deduct a fixed amount from a
cell (I.E. j2)

And the relationship between the date and the amount is ...?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ern" wrote in message
...
I want to put a date in a cell (I.E. a2) and deduct a fixed amount from a
cell (I.E. j2)

Are you looking to display, say today's date in A2, and *also* display the
value of J2 minus a "certain" number?

In A2:
=TEXT(TODAY(),"mm-dd-yy")&" "&J2-20

If you want to use the date from another cell, say A1, and you want to
deduct the number from another cell, say J1, then try this:

=TEXT(A1,"mm-dd-yy")&" "&J2-J1


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"ern" wrote in message
...
I want to put a date in a cell (I.E. a2) and deduct a fixed amount from a
cell (I.E. j2)

Please do not start a second thread on the same topic!
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ern" wrote in message
...
I want to put a date in a cell (I.E. a2) and deduct a fixed amount from a
cell (I.E. j2)