Count Number of Days

[SimonFEBP]

I am having some difficulty figuring out how to enter a formula to count the number of days from a certain date up until today (or whenever the flow is ran).  it works fine if there is a start and end date but also need to count the number of days a task has been open for based on a start date only.

E.G Start Task 1st August - No Completed date as yet - How many days has it been open?

[JamesCharnley · Accepted solution]

Hi @SimonFEBP 

The formula you're going to want to use is DateTimeDiff. If there's no End Date, then you can use DateTimeToday as the second argument. It'd look something like this:

[KrishnaChithrathil]

@SimonFEBP 

[SimonFEBP]

Perfect, Thankyou for the quick reply it worked perfectly/