If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF
Hello,
Having touble using the IF function with dates. IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the result in cell b1 to be 6/15/2009. Thank you everyone! |
#2
|
|||
|
|||
IF
Try this in B1 with your date in A1
=IF(AND(A1=DATE(2009,4,1),A1=DATE(2009,4,30)),DA TE(2009,6,15),"") Format B1 as DATE -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "Susan" wrote: Hello, Having touble using the IF function with dates. IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the result in cell b1 to be 6/15/2009. Thank you everyone! |
#3
|
|||
|
|||
IF
Assuming you simplified your question far too much, are you looking to
produce the 15th of the month that is two months hence (in other words, 7/21/2009 for example would produce 9/15/2009 as a result)? If so, try this formula... =IF(A1="","",DATE(YEAR(A1),MONTH(A1)+2,15)) -- Rick (MVP - Excel) "Susan" wrote in message news Hello, Having touble using the IF function with dates. IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the result in cell b1 to be 6/15/2009. Thank you everyone! |
Thread Tools | |
Display Modes | |
|
|