Forum Discussion
Elisa112
1 year agoHelper V
Networkdays function with blank start dates
Hi Experts I am using the network days function : Meeting date diff= NETWORKDAYS('Meetings'[1st Meeting],'Meetings'[2nd Meeting])-1 However some of the 1st meetings in the column are blank...
Elisa112
1 year agoHelper V
MFelix although I want to ignore any blanks in the 1st meeting column, I do need the dates for the 2nd and 3rd meeting for the customer, see example below of the output I need
Cust ID 1st Meeting 2nd Meeting Day Diff 1-2 3rd Meeting Day Diff 2-3
001 blank 1 Jan 2024 blank 5 Jan 4
002 blank blank blank 7 Jan blank
This is a summarised table, the original meeting table is very large and the meetings, have been ranked, therefore the 3rd meeting is the most recent.
Is there a way to show null if there is no date for the first meeting but still include the record in the table ?
Thank you in advance