formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ern - 29 Dec 2007 16:47 GMT

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

Reply to this Message

Bob Phillips - 29 Dec 2007 16:57 GMT

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

Signature

HTH

Bob

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

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

Reply to this Message

RagDyeR - 29 Dec 2007 17:07 GMT

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

Signature

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)

Reply to this Message

Bernard Liengme - 29 Dec 2007 18:13 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

Reply to this Message