Hi! On my table I have three fields, "Start Date", "End Date", and "Week Number". I am trying to make an automation that extrapolates the week number from the date range. I know there is a formula that does this but I'm looking to have the field be a...
I currently have a 'Date' field that shows year, month and date. I am trying to create a new 'Year' field that is just for the year. Is it possible to create a formula or automation that allows for my new 'Year' field to automatically pull the year f...
I've tried that but it doesn't show the weeks in between - e.g if the dates spans 4 weeks this method doesn't give me the weeks in between, only the week the start and end date is on and even if this did work, i would rather this all be in one field ...
I did but it only lets me pick one date to extrapolate week number for. It doesn't allow me to select both start date and end date so it doesn't solve the issue of extrapolating week numbers from start and end dates that spans multiple weeks.
