Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Part of a bigger project I am working on, I have to figure out numbers of week between Start and End date. From below screenshot, for each Start_date to End_date I want to figure out weeks in 7 days block. I tried using nested If statement as per below. But, it does not satisfy my need. In a nutshell I want to create two new fields as per the Desire screenshot below -- Weeks and Dates .
Will appreciate your advice.
Thanks
Saif
I think the Interval Match function could help you out.
There are some good youtube tutorials on this.