Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating using a date
I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date. A B C 4/28/06 64 1 This is what I wrote, but it's not capturing the date the correct way. If(A227,B2,C2) Thanks in advance of any help anyone can give me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating using a date
Try this...........
=If(DAY(A2)27,B2,C2) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to write an if statement to grab a certain cell if a date is 5 and the # in cell e2 is <4. I am having trouble getting the date. A B C 4/28/06 64 1 This is what I wrote, but it's not capturing the date the correct way. If(A227,B2,C2) Thanks in advance of any help anyone can give me. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating using a date
Thank you so much, that works perfectly.
-- DMM "CLR" wrote: Try this........... =If(DAY(A2)27,B2,C2) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to write an if statement to grab a certain cell if a date is 5 and the # in cell e2 is <4. I am having trouble getting the date. A B C 4/28/06 64 1 This is what I wrote, but it's not capturing the date the correct way. If(A227,B2,C2) Thanks in advance of any help anyone can give me. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating using a date
That solves one problem, now I need to know how I can say
=If(DAY(A2)27,B2,C2)AND B2 IS < 2 THEN B2 IF NOT MAKE IT BLANK DMM "CLR" wrote: Try this........... =If(DAY(A2)27,B2,C2) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to write an if statement to grab a certain cell if a date is 5 and the # in cell e2 is <4. I am having trouble getting the date. A B C 4/28/06 64 1 This is what I wrote, but it's not capturing the date the correct way. If(A227,B2,C2) Thanks in advance of any help anyone can give me. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating using a date
Not real sure I understand your conditions, but give this a try...
=IF(B2=2,"",IF(AND(DAY(A2)27,B2<2),B2,C2)) Vaya con Dios, Chuck, CABGx3 "Dianethetech" wrote: That solves one problem, now I need to know how I can say =If(DAY(A2)27,B2,C2)AND B2 IS < 2 THEN B2 IF NOT MAKE IT BLANK DMM "CLR" wrote: Try this........... =If(DAY(A2)27,B2,C2) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to write an if statement to grab a certain cell if a date is 5 and the # in cell e2 is <4. I am having trouble getting the date. A B C 4/28/06 64 1 This is what I wrote, but it's not capturing the date the correct way. If(A227,B2,C2) Thanks in advance of any help anyone can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Calculating due date? | Excel Worksheet Functions | |||
Calculating due date? | Excel Worksheet Functions |