Related:
- Making date formula using excel.
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to transfer data from one sheet to another in excel using formula - 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.. :(