# Making date formula using excel.

Closed
eli - Oct 1, 2009 at 03:36 AM
eli - Oct 1, 2009 at 06:21 AM
Hello,

i have a date in A1 and giving it a 3 or 6 months expiration date in B1, what formula i should use for it?

thank you so much!

eli,

Blocked Profile
Oct 1, 2009 at 06:07 AM
Dear Eli,

In order to set up a date formula, you will firstly have to configure the 'Function Arguments'.

This is the function that allows you to create the date formula.

If you assigned the following to the Function Arguments:

=DATE(2009,1,1)

Then, you will just have to add 3 or six to the month as in the following formula:

=DATE(2009,4,1) or =DATE(2009,7,1)

Thanks.
i got that. but what i'm trying to do is something like "if" function. i honestly don't know what to do to it. my formula is this..

=IF(A1=A1,DATE(YEAR(B1),MONTH(B1)+3,DAY(B1)+4),DATE(YEAR(B1),MONTH(B1)+6,DAY(B1)+20))

it will come out like; in A1 is where how many months you want to give then in B1 is the date purchased then in C1 is where the answer/expiration will be given. I thought i got it but it seems that i can't use "if" function. and i also can't make A1=A1 in logical test coz it's simply can't decide. Pls, help.. :(