I am not able to understand what do you exactly want.
Please read the question
a) How to calculate number of days between C5 and D5 in row F5 onwards, by looking at row F3 onwards?
Please mention expected value in cell F5, G5 as an example. It will make it easier to assist you.
amit kumar has shared a OneDrive file with you. To view it, click the link below.
Data Set 1.xlsx<https://1drv.ms/x/s!AtV10MTFANYDgRguAji5qopt2yjz>
Thanks for your response.
I don't know how to reply on tableau hence write a mail.
Please see attached file. I am looking at number of days in each month between two time period. I have the formula in the excel file but its too lengthy and taking too much space in excel file. This formula gets replicates across thousand cell. I appreciate if you any software or can help me in shorting the formula.
pastedImage.png 12.2 KB