Forum Discussion

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 ...

excel

Formulas and Functions

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.