calculate number of days between 2 dates

[Anonymous]

I have a table with customer information, including a target start date of the contract and the actual start date. I would like to add an additional column showing the number of days the contract actually started before (negative number) of after (positive number) the target start date. I can't figure out how to do that. Do I need DAX formula's?

[Greg_Deckler]

Generally you create a column flag on your date as to whether it is a business day or not using WEEKDAY. Then you could use that as a FILTER.

[nexami]

@Greg_Deckler 

i've sucessfully added a column which is calculating days between Start Date & End Date. My question is, wherever there is a blank cell in End Date, i want this cell to be considered as today() and calculations continued.

how can it be done

[AmberJane]

@nexami @Greg_Deckler Did you ever figure this out? I need to do the same thing. 

[amolg24]

How about another step further and ending with the number of business days between two date, so exlcuding weekends? Thank you in advance!

[kristy_decicco]

Glorious!  That worked like a charm.  Thanks so much!!