Formula if a cell is blank, run one formula, if not blank run another formula

09/11/20
Accepted

Hello!

I want to track the amount of days a person has been in each stage of their transition – specifically Pre-boarding and Onboarding. I wrote the below formula not thinking that once Pre-Boarding ended and Onboarding started that the formula would keep calculating as I used TODAY. 

What I need is a formula that says “If there is no date in [Actual Affiliation Date]1, calculate total number of days of [Date Assigned to Coach]1 vs TODAY but if there is a date in [Actual Affiliation Date]1, instead calculate total number of days of [Date Assigned to Coach]1 and [Actual Affiliation Date]. 


I messed around a bit and thought I got close but it actually would only return zero so I'm sure I'm much further off then I thought.

=SUMIFS(ISBLANK([Actual Affiliation Date]1), [Date Assigned to Coach]1 - TODAY(), [Date Assigned to Coach]1 - [Actual Affiliation Date]1)

Popular Tags:

Best Answer

Answers

Sign In or Register to comment.