Calculate days between dates

[haider378]

				01-07-18​	01-07-19​	01-07-20​
				30-06-19​	30-06-20​	30-06-21​
Vehicle Name	Start Date	End Date	Days of Policy	FY-2018-19	FY-2019-20	FY-2020-21
Policy 1	01-01-19​	31-12-19​	364	i.e 180.00​	i.e 180.00​	0.00​
Policy 2	28-09-19​	27-09-20​	365
Policy 3	28-09-19​	27-09-20​	365
Policy 4	18-10-19​	17-10-20​	365

 

[etaf]

if formatted as dates
then subtract the dates to get days
Assuming the image starts at A and row1

C4-B4 = gives days of policy and copy down
E$2-E$1 = FY-2018-19 copy down and across

 

[haider378]

not helpful

 

[haider378]

I need to calculate number of days between finical
years based on start date and end date