Related:
- Making date formula using excel.
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel color formula - Guide
- Percentage formula in excel marksheet - Guide
- Vat formula in excel - Guide
1 response
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.
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.
Oct 1, 2009 at 06:21 AM
=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.. :(