I'm attempting to determine how many days there are in a year between two dates.

The outcomes ought to resemble this image in some way.

The range between the 2 dates in the 2021 year has 301 days and in the 2022 year has 94 days.

Dec 28, 2022 in Others 262 views

## 1 answer to this question.

Put this in C2 and copy over:

```=MIN(DATE(C1,12,31),\$B\$2)-MAX(DATE(C1,1,1),\$A\$2)
```

• 63,420 points

## SQL query to select dates between two dates

you should put those two dates between ...READ MORE

## Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

## Excel remaining days count from today until due date minus weekends?

The problem is that you are not ...READ MORE

## Excel VLOOKUP between two sheets failing

Try this: =VLOOKUP(A2,'1'!\$A\$2:\$E\$811,5,0) I altered "1"! \$A\$2:\$A\$811 to '1'! ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE