Forum Discussion
Solved
calculate number of days if cell is empty.
Hello greetings ! I have an excel with 4 columns, in the first column the identification of the quote is recorded, the second column identifies the date the person received the quote by mail...
Jhonny97or Suppose we are looking at row 1, then the formula in D1 could be
=IF(ISBLANK(C1),TODAY()-B1,"")
Riny_van_Eekelen please can you tell me what the formula is used here, I cannot see it.
https://www.youtube.com/watch?v=AtC-A8UPnIE&list=LL&index=2
About 2 minutes into the video
Much appreciated.
Prish_M Not sure why you ask, but at 2 minutes into the video the formulas uses structured table references that take the close date minus the open date in the current row of the table. The "current" row is indicated by the @ sign.
- Just saw you know a lil more about this than me ;-), I was struggling to see the formula on this youtube video. Thanks for the guide, appreciated.