Forum Discussion
Nested IF and DATEDIFF formulas when some date fields are blank
I would like to count the number of days between two date fields: 'datereceived' and 'datedulymade'. I tried to use the DATEDIFF function, BUT - some of the corresponding dates are the same (e.g. num...
Sean
Community Champion
Community ChampionNRW_admin1 You can use DATEDIFF when the dates are the same (see picture below) but you can't have blanks or negative values (to deal with negatives see link at the bottom)
Num of Days =
IF (
ISBLANK ( 'Table'[Made] ),
BLANK (),
DATEDIFF ( 'Table'[Received], 'Table'[Made], DAY )
)
Also see response here... (although this doesn't deal with Blank may give some ideas)
Problem solved, combined with guidance in the link. Many thanks :)