Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Calculate date for tasks

Copper Contributor

I am working on a template for a product launch. There are many tasks that need to take place over several months in order to be ready by the launch date. No matter the launch date, some tasks will always need to be done 30 days prior to launch for example. Is there a way to say how far prior to the launch date a task needs to be done, then when I put in the launch date Excel will populate the date each task should be done by? Hopefully that makes sense, any advise on this would be great, thanks in advance!

1 Reply
can you provide a sample file without sensitive data? it will be much better if you could also manually put the goal that you wanted.