Calculate days duration between startdate and enddate

[pala_jagadeesh]

Hi,

I have Startdate and Enddate, from this I want to calculate days duration like below

Time gap:
0-14 days
15-28 days
>28 days

startdate	enddate
25-Oct-2022	29-Oct-2022
28-Oct-2022	02-Nov-2022
25-Nov-2022	30-Dec-2022
30-Nov-2022	30-Dec-2022
02-Dec-2022	31-Dec-2022

[Or · Accepted solution]

Looks to fit in an if() statement:

If(enddate - startdate>28,'>28 days',if(enddate - startdate)>=15,'15-28 days','0-14 days'))