question : is it 91+90=181 or 92+89=181 for both years ?![]()
=MAX(0,MIN(DATE(Table2[[#Headers],[2018]],1,1),$C3)-MAX(DATE(Table2[[#Headers],[2017]],1,1),$B3))
question : is it 91+90=181 or 92+89=181 for both years ?![]()
=MAX(0,MIN(DATE(Table2[[#Headers],[2018]],1,1),$C3)-MAX(DATE(Table2[[#Headers],[2017]],1,1),$B3))
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Thank you very much for your input. That is exactly what I needed. Concerning your question: It would be rather 91+90.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks