Forum Discussion
Excel formulas for day counting
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...
Dates are integers in excel, so 15-1=14. If you want to include the last day, then add one (=B1-A1+1).
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
Hopefully i can one day as well