Forum Discussion
PamGBC
Aug 22, 2023Copper Contributor
Series of 2 week dates in excel
How do I fill a series of 2 week date increments in excel.
ie: 8/6/2023-8/19/23
next row, same column cell = 8/20/2023-9/2/2023
There is no dedicated web part for Draw.io (Sorry I don't know what this is) in SharePoint Online.
However, there is a generic File viewer web part in SharePoint Online. You can try using it if that works for you. Check below reference for more information on this web part:
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it b.
2 Replies
Sort By
I'd use two columns.
For example, enter 8/6/2023 in A2.
In A3, enter the formula =A2+14, then fill down.
In B2, enter the formula =A2+13, and fill down too.
If you wish, you can combine them in a third column:
In C2, enter the formula =TEXT(A2,"m/d/yyyy")&"-"&TEXT(B2,"m/d/yyyy") and fill down.
- PamGBCCopper ContributorExcellent idea - thanks!