SUMIF date within a date range
shaenwe
Posted messages
1
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I have 3 columns, in A the start date of the loan, in B the end date of the loan, and in C the number of chairs loaned (I have 230 in total).
I would like to create on a second sheet (or on the same one by splitting the page to see both at the same time), a "calendar" with the date in the first column (January 1st, January 2nd, etc.) and a second column where it returns the number of remaining chairs. I tried using SUM.IF but I don't see how to make it check that my single date cell is included in the date range (in the form of 2 columns for the start date of the loan and a second for the end date of the loan).
I'm sure it's doable but I’m stuck at the moment :s
Could someone enlighten me? ^^
Thanks in advance :-)
I have 3 columns, in A the start date of the loan, in B the end date of the loan, and in C the number of chairs loaned (I have 230 in total).
I would like to create on a second sheet (or on the same one by splitting the page to see both at the same time), a "calendar" with the date in the first column (January 1st, January 2nd, etc.) and a second column where it returns the number of remaining chairs. I tried using SUM.IF but I don't see how to make it check that my single date cell is included in the date range (in the form of 2 columns for the start date of the loan and a second for the end date of the loan).
I'm sure it's doable but I’m stuck at the moment :s
Could someone enlighten me? ^^
Thanks in advance :-)
