calculate days

[ADIB]

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

 

[Bob Phillips]

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

 

[Shane Devenshire]

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

 

[ADIB]

HI Shane
i need the date that will appear in b1 after complition of 30 days.it mean