Looking to create a formula that asks if the date range specified in equal to or greater than date above then "1" otherwise "0"
I apologize if unclear. thanks!
Capture.JPG
Looking to create a formula that asks if the date range specified in equal to or greater than date above then "1" otherwise "0"
I apologize if unclear. thanks!
Capture.JPG
macros work...
Please Login or Register to view this content.
A simple IF() function should handle this. Note that "between" is an AND() function. Perhaps the hardest part of the function is getting the relative and absolute references correct (here if you are unfamiliar with relative and absolute referencing in spreadsheets: https://support.office.com/en-ca/art...es_in_formulas ).Your picture cuts off the row and column labels, so I am assuming the upper left is A1.
=IF(AND($A2<=C$1,C$1<=$B2),1,"") -- note how I mixed relative and absolute references to make this easy to copy.
Originally Posted by shg
In C2:
=AND(C1>=A2,C1<=B2)+0
Drag accross
Quang PT
bump other replies are better
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks