Calculate Due Date

[Guest]

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

 

[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

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"

 

[Guest]

It gives error #Value!

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"

 

[Guest]

Hi Ajit
Check if the dates are formatted as text.
Sukhjeet

 

[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

 

[Dave Peterson]

VBA Strikes Back!

=DATE(RIGHT(B5,4),MID(B5,4,2),LEFT(B5,2))+40