G
Guest
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
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