Excel formulas for day counting

Question

why is it that my formula for counting days using in between dats seems to not be counting either my first day or very last day? for instance enter date 5-1-22 and exit date 5-15-22, should be 15 but it only counts 14? How can i fix this

riny_van_eekelen · Answer

dlcusic1&nbsp;Dates are stored as numbers and Excel merely calculates the difference between two numbers. Just like 10 - 1 = 9 , though when counting from day 1 to day 10 you'll end up with 10 days. So, with dates you must add 1 if that's what you need.&nbsp;&nbsp;

jmb17 · Answer

dlcusic1&nbsp;Dates are integers in excel, so 15-1=14. If you want to include the last day, then add one (=B1-A1+1).

dlcusic1 · Answer

Thank you so much. You guys are amazing!!

dlcusic1 · Answer

Thank you so much. I can believe the help you can get her just by asking... This is an amazing tool. I appreciate every one that has the knowledge and willing to share 🙂
Hopefully i can one day as well

Forum Discussion

Excel formulas for day counting

4 Replies

Resources