Related:
- Making date formula using excel.
- Date formula in excel dd/mm/yyyy - Guide
- Excel color formula - Guide
- Number to words in excel formula - Guide
- Formula to calculate vat in excel - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
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.. :(