Hi guys, every fortnight I need to complete a timesheet, which is always the same - Monday - Friday, same number of hours. The only thing that alters every two weeks is the dates.
Is there a way to automatically increase each previous date by 14 days? I've played around a bit but can't seem to get a formula to do this seemingly simple task. I'd be grateful if someone could steer me in the right direction.
TIA
Is there a way to automatically increase each previous date by 14 days? I've played around a bit but can't seem to get a formula to do this seemingly simple task. I'd be grateful if someone could steer me in the right direction.
TIA