Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
This formula is not working. Can you please help me correct it?
=IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes") If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it to return as blank. If false (no date in that range), then I want it to return "Yes". Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
Try this.
=IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/2008"),'Employee Attendance'!3:3<DATEVALUE("4/31/2008")),"","Yes") "hmsawyer" wrote: This formula is not working. Can you please help me correct it? =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes") If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it to return as blank. If false (no date in that range), then I want it to return "Yes". Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
That doesn't work either. I'm still getting #VALUE. Thanks.
"Mike" wrote: Try this. =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/2008"),'Employee Attendance'!3:3<DATEVALUE("4/31/2008")),"","Yes") "hmsawyer" wrote: This formula is not working. Can you please help me correct it? =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes") If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it to return as blank. If false (no date in that range), then I want it to return "Yes". Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
Try it this way:
=IF(COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,30))0,"","Yes") Hope this helps. Pete On Mar 24, 10:50*pm, hmsawyer wrote: That doesn't work either. *I'm still getting #VALUE. *Thanks. "Mike" wrote: Try this. =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/2008"),'Employee Attendance'!3:3<DATEVALUE("4/31/2008")),"","Yes") "hmsawyer" wrote: This formula is not working. *Can you please help me correct it? =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes") If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it to return as blank. *If false (no date in that range), then I want it to return "Yes". Thank you.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
That is better, but it is only returning Yes even when there are dates in
April in the line. Any other thoughts? "Pete_UK" wrote: Try it this way: =IF(COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,30))0,"","Yes") Hope this helps. Pete On Mar 24, 10:50 pm, hmsawyer wrote: That doesn't work either. I'm still getting #VALUE. Thanks. "Mike" wrote: Try this. =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/2008"),'Employee Attendance'!3:3<DATEVALUE("4/31/2008")),"","Yes") "hmsawyer" wrote: This formula is not working. Can you please help me correct it? =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes") If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it to return as blank. If false (no date in that range), then I want it to return "Yes". Thank you.- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
I suppose you are getting "Yes" with dates of 1st April? You need to amend
the first part of the formula so that it is "=", i.e.: =IF(COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,30))0,"","Yes") It would be a bit easier to modify for other months if you change it further to this: =IF(COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,5,1))0,"","Yes") i.e. the first date is the 1st of the month you are interested in, the second date is the first of the next month, and both COUNTIFs are now looking at "=" the date. Hope this helps. Pete "hmsawyer" wrote in message ... That is better, but it is only returning Yes even when there are dates in April in the line. Any other thoughts? "Pete_UK" wrote: Try it this way: =IF(COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,""&DATE(2008,4,30))0,"","Yes") Hope this helps. Pete On Mar 24, 10:50 pm, hmsawyer wrote: That doesn't work either. I'm still getting #VALUE. Thanks. "Mike" wrote: Try this. =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/2008"),'Employee Attendance'!3:3<DATEVALUE("4/31/2008")),"","Yes") "hmsawyer" wrote: This formula is not working. Can you please help me correct it? =IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes") If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it to return as blank. If false (no date in that range), then I want it to return "Yes". Thank you.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|