Steven Guard
asked on
date bucketing
Hi There
I want to create a report that buckets dates in fortnightly amounts. across the page so will be separate formulas
What formula can I use to create the first 14 days?
I would then use another formula to add 14 days to top of each one This is not a group heading
currently use this formula for start of current week (dateadd("d",7-dayofweek(c urrentdate )+2,curren tdate))-7
Can I use a similar one for fortnight?
Cheers
Steve
I want to create a report that buckets dates in fortnightly amounts. across the page so will be separate formulas
What formula can I use to create the first 14 days?
I would then use another formula to add 14 days to top of each one This is not a group heading
currently use this formula for start of current week (dateadd("d",7-dayofweek(c
Can I use a similar one for fortnight?
Cheers
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.