Finding a date (N30) in a date range B5:B30 and returning A3text
Solved/Closed
Kelley
-
Apr 29, 2015 at 05:15 AM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 29, 2015 at 07:06 AM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 29, 2015 at 07:06 AM
Hello,
Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula....
I have a column with different dates in each cell (B25:B34). I also have some random dates listed in other cells (eg, N30). I would like a formula in cell N31 that will look up the date range (B25:B34) and if the date that is in N30 appears in the date range, then produce the result of text "school" (or cell "A3" as the word "school" already appears in that cell). If the date doesn't appear in the range (B25:B34) then leave the cell empty.
Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula....
I have a column with different dates in each cell (B25:B34). I also have some random dates listed in other cells (eg, N30). I would like a formula in cell N31 that will look up the date range (B25:B34) and if the date that is in N30 appears in the date range, then produce the result of text "school" (or cell "A3" as the word "school" already appears in that cell). If the date doesn't appear in the range (B25:B34) then leave the cell empty.
Related:
- Finding a date (N30) in a date range B5:B30 and returning A3text
- Apple airtag range - Guide
- How to increase the wifi range - Guide
- Ps3 not finding update on usb - Guide
- If function with date range - Guide
- Karbikes electric bike range - Home - Apps & Sites
1 response
MaxStart
Posts
338
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Apr 29, 2015 at 06:06 AM
Apr 29, 2015 at 06:06 AM
=IF(COUNTIF(B25:B34,N30),"school","")
Apr 29, 2015 at 06:10 AM
So very grateful!
Kelley
Apr 29, 2015 at 07:06 AM