Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community ,
i want start date minus end date. i have table like
date |
16-Apr-2023 |
17-Apr-2023 |
18-Apr-2023 |
19-Apr-2023 |
20-Apr-2023 |
21-Apr-2023 |
22-Apr-2023 |
23-Apr-2023 |
24-Apr-2023 |
25-Apr-2023 |
26-Apr-2023 |
here 16 is startdate & 26 is enddate
expected output:
finaldate |
-10 |
@inam If your date is in proper date format you can try below
=min(Date)-max(Date)
or
min(total Date)-max(total Date)