Formula for count date

**sanam** · 11-26-2009, 07:05 AM

Hello,

Please find the attached sample sheet. When I write number of days in column B. I need formula for column C to automatically show what date it will be. Hope someone understands my explanation. Thank you for any help.

**DonkeyOte** · 11-26-2009, 07:10 AM

You mean perhaps

C2: =SUM(A2,1,B2)

**sanam** · 11-26-2009, 07:15 AM

Is that simple

thanks donkeyOte for your help and Quick response

**sanjay07** · 11-26-2009, 07:51 AM

hey thats great ..........could u just explain it in detail

**Palmetto** · 11-26-2009, 09:05 AM

hey thats great ..........could u just explain it in detail

See the Excel Help on the SUM function.

In the attachment the OP wants to calculate a future date by adding a value to the current date and he showed the expected new date.

A2: = current date using the function TODAY()
B2: = a given numeric value ( 60 )
C2: = expected new date: 1/26/2010

Dates in Excel are actually serial numbers. On the PC platform, January 1, 1900 is considered "day 1". Today, 11/26/2009 = 40143 (days since 1/1/1900).

Because Today's date + 60 does not equal 1/26/2010 it is necessary to add "1" in the calculation (or change the given numeric value from 60 to 61).

Formula:=SUM(A2,1,B2) = (40143 + 1 + 60 ) = 40204 (which formatted as a date is 1/26/2010.