EDIT: SOLVED --- I figured it out myself
It looks like this now:
I have this conditional function:![]()
=IF(AND(DATEVALUE(F1) <= 39259, DATEVALUE(F1) > 39029), "Epoch 109", "N/A" )
For F1 use: Dec 17, 2007![]()
=IF(AND(F1 <= DATE(2007,6,26), F1 >= DATE(2006,11,8)), "Epoch 109", "N/A" )
For F2 use: Feb 24, 2007
F1 should be: N/A
and F2 should be: Epoch 109
Correct?
Why does it not display that?
Bookmarks