View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

If your invoice date is in cell A1 and say its due 30 days from the invoice
date then the due date is simply
=A1+30

Also take a look at function WORKDAY if the due date has to be a working day
that is Mon thru friday (assuming Sat and sunday are non-working days)


"due date for payable invoice" <due date for payable
wrote in message
...
I need to know how to calculate due dates automatically by enetering the
date
of invoice in one cell and correspondingly the due date should be
displayed.
Please advise if there is any possible macros or conditional formatting or
any special formulas for it.

Thanks
Predeep.S