Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Hello,
Having problem using the IF function with dates. If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the result in B1 should be 6/15/2009. Thank you everyone! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
=IF(AND(A1DATEVALUE("3/31/2009"),A1<DATEVALUE("5/1/2009")),DATEVALUE("6/15/2009"),"") and format as date.
-- Gary''s Student - gsnu200846 "Susan" wrote: Hello, Having problem using the IF function with dates. If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the result in B1 should be 6/15/2009. Thank you everyone! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Another one using DATE
=IF(AND(A1=DATE(2009,4,1),A1<=DATE(2009,4,30)),DA TE(2009,6,15),"") If this post helps click Yes --------------- Jacob Skaria "Susan" wrote: Hello, Having problem using the IF function with dates. If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the result in B1 should be 6/15/2009. Thank you everyone! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Ignoring my attempted general solution posted elsewhere in this thread, if
you really are interested only in April dates becoming June 15th dates, then perhaps this will do what you want... =IF(MONTH(N1)=4,DATE(YEAR(N1),6,15),"") -- Rick (MVP - Excel) "Susan" wrote in message ... Hello, Having problem using the IF function with dates. If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the result in B1 should be 6/15/2009. Thank you everyone! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Or, if the year is important, maybe this...
=IF(AND(MONTH(A1)=4,YEAR(A1)=2009),--("6/15/2009")) -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... Ignoring my attempted general solution posted elsewhere in this thread, if you really are interested only in April dates becoming June 15th dates, then perhaps this will do what you want... =IF(MONTH(N1)=4,DATE(YEAR(N1),6,15),"") -- Rick (MVP - Excel) "Susan" wrote in message ... Hello, Having problem using the IF function with dates. If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the result in B1 should be 6/15/2009. Thank you everyone! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|