How do I count days between dates if I want to get an answer of 1 if the dates are the same.
For example, a result of 1 day if the two dates are 3/28/18 and 3/28/18
How do I count days between dates if I want to get an answer of 1 if the dates are the same.
For example, a result of 1 day if the two dates are 3/28/18 and 3/28/18
Assume first date is in A1 and Second date is in B1
C1Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Or:
=B1-A1+(B1=A1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks