hi!

why don't you try

in B1; =A1+30 &
in C1; = A1+82

where A1 having the order date, B1 having the payment date and C1
containing the delivery date!?

-via135





deniseh Wrote:
I am trying to organise dates in an easy format for say, to place an
order,
calculate a payment date and then an expected delivery date. So far I
can
calculate the dates for payment date and expected delivery by adding 30
days
to original order date and then 82 days to order date for expected
delivery
etc. I have a spreadsheet in Excel which calculates the dates but
doesn't
populate automatically so any alterations to the order date I have to
recalculate and then input into the spreadsheet. I had thought a
calendar
would be of more use, and easier to see etc. Has anyone any ideas if
this is
possible?
Thanks for your time.
Denise


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=529548