• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count days off from date range

Maride

New Member
I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input


6/7/21 - 6/10/21
6/8/21 - 6/8/21
6/8/21 - 6/9/21
and be able to get a list

6/7/21 - 1
6/8/21 - 3
6/9/21 - 2
6/10/21 1
 

vletm

Excel Ninja
Maride
You should reread Forum Rules
There are clear steps, if someone would use Cross-posting.
 

deciog

Active Member
Maride Good Morning.

I was in doubt, the ideal is to post a model so we can make the formula and test it

Check if this is the way you want

decio
 

Attachments

vletm

Excel Ninja
Maride
#1 Seems that You do not notice at all that You do not follow Forums Rules.
Those rules are for Your too, which everyone should follow.
... There are same kind of rules in every Forum too.
Do You understand this?

#2 About Your I'm sorry I don't understand.
You're using term Days Off ... Did You notice that?
How do other knows - what are Your Days Off , if You won't explain those.
 

Maride

New Member
Maride
#1 Seems that You do not notice at all that You do not follow Forums Rules.
Those rules are for Your too, which everyone should follow.
... There are same kind of rules in every Forum too.
Do You understand this?

#2 About Your I'm sorry I don't understand.
You're using term Days Off ... Did You notice that?
How do other knows - what are Your Days Off , if You won't explain those.

Sorry by days off I mean the days the employee has requested to take off so I am trying to track PTO requests without having to input each individual day as my reporting system pulls start and end date for their PTO time
 

Maride

New Member
Maride Good Morning.

I was in doubt, the ideal is to post a model so we can make the formula and test it

Check if this is the way you want

decio
Close but I have a start date and end date for my data input and I want it to count the dates in between as well
 

Attachments

Top