Copy link to clipboard
I am working on a form where I want to subtract my date field from a "week" field to create a new date. I am creating a timeline for my workbook. So the equation I want is
(Date of the Event)-(Week Form)*7=Date
I can get to formula to pop out the number of days but I cannot get it to format into a date field.
I will need to do a similar formula but with time where I subtract hours from a "start time" so the formula will be (Start Time)-(Hours)=Time
Thank you in advance.
Have something to add?