Dates - Nth date formula
Options

hclacken
✭✭✭
Good afternoon,
I have searched the smartsheets community far and wide for this answer to no avail. Would anyone be able to assist me in creating formulas for two different scenarios:
1.) I need dates for every Friday for the remainder of the year
2.) I need dates for every second Thursday and Friday for the reminder of the year
I have to find a formula that will work for this
Tags:
Answers
-
Would you just be able to add 7 to the first Friday of the year, then drag that formula down? The only change then for every second Thursday/Friday is to add 14 instead of 7.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!