Thread: Workdays issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lorderon Lorderon is offline
external usenet poster
 
Posts: 13
Default Workdays issue

Hi,
In cell A1, i have the start date
In cell B1, i have the duraiton in working days

I want to put a formula in cell C1 to give me the date from the start date
(cell A1) given the difference shown in the duration (cell B1)..

Example:
Cell A1 = Jan 2, 2009
Cell B1 = 5 days
By right, cell C1 should be equal to Jan 9, 2009

How to do it? What formula to put in cell C1??

Thanks!