Hi
I want to calculate the number of days between 2 dates but including the dates themselves.
e.g. start date 3rd Feb, end date 4th Feb. This represents 2 full days but excel calculates it as 1.
any ideas?
thanks
Hi
I want to calculate the number of days between 2 dates but including the dates themselves.
e.g. start date 3rd Feb, end date 4th Feb. This represents 2 full days but excel calculates it as 1.
any ideas?
thanks
Add + 1 to the end of the formula
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks