Calculate Due Date

A

Ajit

Kindly guide me in calculating Due Date in Excel worksheet.

In Column "B" there are some dates.

I want to calculate due dates after adding 40 days from date mentioned in Column "B" to be displayed in Column "C"

Eg:

In column "B" Date is 01/06/2004 then after adding 40 days date in column "C" must be 10/07/2004

Pls guide me
Ajit
 
N

Nikos Yannacopoulos

Ajit,

In cell C5, for instance, the formula should be: =B5+40; enter the formula
in your top cell in column C, copy down and format the column as date and
you're done!

HTH,
Nikos

Ajit said:
Kindly guide me in calculating Due Date in Excel worksheet.

In Column "B" there are some dates.

I want to calculate due dates after adding 40 days from date mentioned in
Click to expand...
Column "B" to be displayed in Column "C"
 
A

Ajit

It gives error #Value!

Nikos Yannacopoulos said:
Ajit,

In cell C5, for instance, the formula should be: =B5+40; enter the formula
in your top cell in column C, copy down and format the column as date and
you're done!

HTH,
Nikos


Column "B" to be displayed in Column "C"
Click to expand...
 
N

Nikos Yannacopoulos

Ajit,

Are your dates in column B formatted as text? If that's the case, then
change the C5 formula to:

=DateSerial(Right(B5,4),Mid(B5,4,2),Left(B5,2))+40

HTH,
Nikos
 
Top