# Number of Days Calculation

1. ## Number of Days Calculation

I for the life of me don't know why I am having such a hard time with this one as soon as someone answers this I'm going to be like of course! lol

I have a Start Date and End Date I need the total number of days not the difference in days this is the formula I have so far..

=(DAYS(U11,T11))+1

However I want to carry the formula down to empty rows that do not yet have both start dates and end dates so if the date equals "1" because both start date and end date are empty I want it to return blank
If there is only a Start Date currently it returns a negative value and I want it to return Blank in that scenario as well.

I know there is multiple formulas to calculate the difference in days I'm not set on using this one specifically if there is a better one that works for this case.

Thank you in advance for you help on this,

Sugar

2. ## Re: Number of Days Calculation

Try this:

=IF(OR(U11="",T11=""),"",U11-T11+1)

Copy down as required.

Hope this helps.

Pete

3. ## Re: Number of Days Calculation

THANK YOU SO MUCH! I was trying to do the IF conditions at the end not the beginning smh I knew it was simple lol

4. ## Re: Number of Days Calculation

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

5. ## Re: Number of Days Calculation

I did not know that, thank you for sharing =)

There are currently 1 users browsing this thread. (0 members and 1 guests)