formula

[ern]

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

 

[Bob Phillips]

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)

 

[RagDyeR]

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!
=====================================================


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

 

[Bernard Liengme]

Please do not start a second thread on the same topic!