# Formula Help: Determine days total from arrival to current date then stop adding days

1. ## Formula Help: Determine days total from arrival to current date then stop adding days

I am looking for help for a formula that calculates the number of days between an entered date and the current date and then once another cell has been filled, it will lock the days at that number and stop accumulating more days.
As in How many days has unit been in shop calculated from units arrival date to current date, but once there is a shipped date, how many days in shop stops calculating more days.

Attached is an example of my sheet that may help you understand it better since I do not think I am doing a very good job at wording it.

2. ## Re: Formula Help: Determine days total from arrival to current date then stop adding days

In E2 and copied down:

Formula:
`Please Login or Register  to view this content.`

BSB

3. ## Re: Formula Help: Determine days total from arrival to current date then stop adding days

Try

=IF(D2="",TODAY(),D2)-B2

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1