CODEWITHSUNDEEP
excel
user2989548
user2989548

Reputation: 3

Excel formula to work out days

Im trying to work out a formula in excel 2013, that will return an answer with a conditional criteria of 2 things.
In cell A1, i have a started date, Cell B1 will either be blank or contain a completed date, then Cell C1 is to return a number of days that is either the total number of live days to today, or to the date that is in B1?

Any help would be muchly appreciated.

Kindest Regards

Isreal.

Upvotes: 0

Views: 116

Answers (2)

barry houdini
barry houdini

Reputation: 46331

Try this formula in C1

=IF(B1="",TODAY(),B1)-A1

format C1 as general

Upvotes: 1

Netloh
Netloh

Reputation: 4378

You could do this by using this formula in cell C1:

=IF(B1<>"",B1-A1,TODAY()-A1)

Upvotes: 2

Related Questions