Search : in
By :

Making date formula using excel.

Last answer on Oct 1, 2009 11:21:18 am BST eli, on Oct 1, 2009 8:36:02 am BST 
 Report this message to moderators

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?
please help me..

thank you so much!

eli,

Configuration: Windows XP
Firefox 3.0.14

Best answers for « making date formula using excel. » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Difference between dates with the DATEDIF function ShowDifference between dates with the DATEDIF function The Syntax Example Making use of: Notes The DATEDIF function is not documented in Excel, here are some informations about it The Syntax =DATEDIF(start date;end date;type of...
Ask your question Reply

1

dybbody, on Oct 1, 2009 11:07:32 am BST

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.

   
Reply to dybbody

2

 eli, on Oct 1, 2009 11:21:18 am BST

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.. :(

   
Reply to eli
Ask your question Reply
They need your help