Forum Discussion

wadethebluedevil's avatar
wadethebluedevil
Copper Contributor
Apr 28, 2023

Trying to use If function with other formulas for Date

I know im probably making this more difficult than it should be but here is my current code:

=IF(H6="date",DAYS(D1,D6)-DAYS(D1,H6),IF(H6="",DAYS(D1,D6)))

basically I want it to count days from one entered date to current date but if I put a completion date in another cell I want It to stop counting and leave the number its at. Is this possible? Am I using the correct function and formulas? Please help 

 

Thank You

-Wade 

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 28, 2023

    wadethebluedevil 

    Not sure I understood what is where. Assuming

    D1 - start date

    D6 - end date or empty

    it could be

    =IF( D6="", TODAY(), D6) - D1

    and apply General format to the result.

Resources