Hi,
in A1 there is date 1/25/2009 i want in B1 2/26/2009 after 30 days . can it
possible
please anyone solve the above

Thanks in advance

What do you mean? You want to add 30 days to A1, or you want that date to
appear after 30 days?

--
__________________________________
HTH

Bob

"ADIB" wrote in message
...
Hi,
in A1 there is date 1/25/2009 i want in B1 2/26/2009 after 30 days . can
it
possible
please anyone solve the above

Thanks in advance

Hi,

there is a problem with your question 2/26/09 is 32 days after 1/25/09. If
you want to add 30 days when A1 has 1/25/09 in it just type =A1+30 into
another cell.

If you are trying to add 1 month and 1 day then

=EDATE(A1,1)+1

EDATE is part of the ATP, so you need to attach it - choose Tools, Add-ins,
and check Analysis ToolPak

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"ADIB" wrote:

Hi,
in A1 there is date 1/25/2009 i want in B1 2/26/2009 after 30 days . can it
possible
please anyone solve the above

Thanks in advance

HI Shane
i need the date that will appear in b1 after complition of 30 days.it mean
on 31 day date will appear in b1.any help please.

"Shane Devenshire" wrote:

Hi,

there is a problem with your question 2/26/09 is 32 days after 1/25/09. If
you want to add 30 days when A1 has 1/25/09 in it just type =A1+30 into
another cell.

If you are trying to add 1 month and 1 day then

=EDATE(A1,1)+1

EDATE is part of the ATP, so you need to attach it - choose Tools, Add-ins,
and check Analysis ToolPak

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"ADIB" wrote:

Hi,
in A1 there is date 1/25/2009 i want in B1 2/26/2009 after 30 days . can it
possible
please anyone solve the above

Thanks in advance