Trying to count days between to dates to a maximum number
I am new to the forum and in need of some assistance. I am trying to count the number of days between two dates in column A and B up to a maximum number of 180 days, after that I would like to display a value of 180. Any assistance would be appreciated.
That worked perfectly.
Last edited by michaj; 08-19-2011 at 10:32 AM. Reason: Problemed solved... thank you.
Assuming dates begin in A1:
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
=min(b1-a1, 180)
Entia non sunt multiplicanda sine necessitate
Worked perfectly.. thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks