G
Guest
Guest
Hello all,
Sorry to bother you, but I have a question in Excel that seems too difficult for me.
I work for a smaller airline and we use Excel as a database of our flights. I have a sheet with a starting date, say in column B, and a ending date, say in column C. Let's assume that the flight operates every Monday, that means that the dates in both column B and C are Mondays.
I have created one column for each month in the year, let's say they are in column D:O with January in D, February in E and so on.
What I am looking for is a formula and a solution to calculate how many trips this aircraft makes in January, in February and so on based on the period typed in column B and C. For example: If I select the starting date to be 2002-04-01 (Monday) and the end date to be 2002-05-20 (Monday) the same row should say "5" under April and "3" under May for the number of Mondays in April and May respectively.
If you have ANY suggestions or help at all for me, I would be MOST grateful!
Thanks in advance,
Marcus
marcus.karlsson@apollo.se
Sorry to bother you, but I have a question in Excel that seems too difficult for me.
I work for a smaller airline and we use Excel as a database of our flights. I have a sheet with a starting date, say in column B, and a ending date, say in column C. Let's assume that the flight operates every Monday, that means that the dates in both column B and C are Mondays.
I have created one column for each month in the year, let's say they are in column D:O with January in D, February in E and so on.
What I am looking for is a formula and a solution to calculate how many trips this aircraft makes in January, in February and so on based on the period typed in column B and C. For example: If I select the starting date to be 2002-04-01 (Monday) and the end date to be 2002-05-20 (Monday) the same row should say "5" under April and "3" under May for the number of Mondays in April and May respectively.
If you have ANY suggestions or help at all for me, I would be MOST grateful!
Thanks in advance,
Marcus
marcus.karlsson@apollo.se