Related:
- Making date formula using excel.
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Percentage formula in excel marksheet - Guide
- Excel color formula - Guide
- Excel mod apk for pc - Download - Spreadsheets
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.. :(