Excel Calculate date difference wherever a date appears

davidcantor
3StarLounger
Posts: 247
Joined: 05 Nov 2012, 19:40

Excel Calculate date difference wherever a date appears

Post by davidcantor »

I have an excel Pivot with data like this
Type Date1 Date2 DateDiff
1 1/1/20 12/1/19
2 1/2/20
3 1/3/20 10/1/19
4 1/4/20
5 1/5/20 15/12/19
6 1/6/20


I only need the difference (number of days) between date1 and date2 if there is a date on the date2 column

User avatar
HansV
Administrator
Posts: 78386
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Calculate date difference wherever a date appears

Post by HansV »

Could you attach a small sample workbook? Thanks in advance.
Best wishes,
Hans