Excel formual to meet deadlines

May 21, 2020 at 11:51:36
Specs: Windows 10
I'm hoping to create an Excel formula for this equation:

If my newsletter will be published on a Tuesday, I need to make sure that it is already with my Design team by Thursday of the previous week.

If my news letter will be published on a Friday, I need to make sure that it is already with my design team by Tuesday of the previous week.


See More: Excel formual to meet deadlines

Reply ↓  Report •

#1
May 21, 2020 at 12:00:12
First, this question should be posted in the Office forum, not the Windows 10 forum. I will move it later.

Second, how is a formula going to "make sure that it is already with your Design team"?

A formula needs inputs in order to produce an output. Since we can't see your worksheet from where we are sitting, nor do we know anything about your work processes, you will need to supply some more information before we can offer a solution.

What are the inputs to this formula? Where are they? What are you expecting as an output? etc.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
May 21, 2020 at 14:44:14
Why do this with excel?

Sounds like you need a script(to check dates and move files), id recommend looking into powershell.

If you provide some more info i could help write a script, like what are the file extensions, do you send the files via mail or upload to local network folder?

Like DerbyDad03 said, we cant really help unless we know more about the process..


Reply ↓  Report •
Related Solutions


Ask Question