Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you want a TRUE/FALSE answer you don't need the IF() function.
Just use =AND(DAY(A1)=30,MONTH(A1)=6) -- David Biddulph "pinmaster" wrote in message ... Hi, Try: =IF(AND(DAY(A1)=30,MONTH(A1)=6),TRUE,FALSE) HTH Jean-Guy "The BriGuy" wrote: I have a coumn that I simply put dates into. What I want to do is if the month and day = certain criteris then TRUE results, if not then FALSE. For exaple the date listed is 6/30/06 so if the date is 6/30/any year then this is a TRUE statement. I know this is probably simple but I seldom use EXCEL. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dates and formulas | Excel Discussion (Misc queries) | |||
USING DATES IN FORMULAS | Excel Discussion (Misc queries) | |||
Dates Not Formatting as Dates | Excel Worksheet Functions | |||
Using dates in formulas | Excel Worksheet Functions | |||
help with formulas and dates??? | Excel Discussion (Misc queries) |