Counting days in a row

I have this column of dates (in this format) and want to calculate the days starting from 01-01-2021 and ending 31-12-2021.

Can anyone help me?

Regards

Kjaer

Days.xlsx

Date Time

Accepted answers

atcodedog05

Hi @Kjaer

Try this

Workflow:

Hope this helps : )

Days (2).yxmd

All comments

apathetichell

your dates fed in as dates on my machine so I didn't have to do any conversions - assuming this is true in your workflow - use multi-row formula configured as pictured.

date counter.png

binu_acs

@Kjaer , similar approach like @apathetichell , just added the DateTimeParse method

Days.yxmd

Kjaer

@binu_acs

Thanks for the solutions. In this case my input is a tabel from excel like the one I posted. That means that I have to make a change in the date format before it works. I have tried but no. Can you help me.

Qiu

@Kjaer
It works just in my test.
The alteryx imported the data in Date Format.
Can you show your example?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703