Solved 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 •

✔ Best Answer
May 29, 2020 at 11:21:36
Put this formula in B10

=IF(WEEKDAY(B10)=6,B10-10,IF(WEEKDAY(B10)=3,B10-5,""))
=IF(WEEKDAY(B9)=6,B9-10,IF(WEEKDAY(B9)=3,B9-5,""))

See how that works for you.

Minor edit,oops.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy



#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 •

#3
May 29, 2020 at 04:39:59
	A1	B1	C1	D1	E1	F1	G1
A2	Sun	Mon	Tue	Wed	Thur	Fri	Sat
A3		1	2	3	4	5	6
A4	7	8	9	10	11	12	13
A5	14	15	16	17	18	19	20
A6	21	22	23	24	25	26	27
A7	28	29	30				
							
A9	RD	B9					
A10	DT	B10					
					

Here's how my worksheet looks like. If I enter a date in B9, I want B10 to show:
1. Thursday of the previous week if B9 falls on a Tuesday.
2. Tuesday of the previous week if B9 falls on a Friday.

Reply ↓  Report •

Related Solutions

#4
May 29, 2020 at 11:21:36
✔ Best Answer
Put this formula in B10

=IF(WEEKDAY(B10)=6,B10-10,IF(WEEKDAY(B10)=3,B10-5,""))
=IF(WEEKDAY(B9)=6,B9-10,IF(WEEKDAY(B9)=3,B9-5,""))

See how that works for you.

Minor edit,oops.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#5
May 30, 2020 at 12:28:38
I think the data table (calendar) should look like the following, but I don't quite understand why it was posted.

The only thing that matters is the date entered in B9 and the formula in B10...unless I missed something.

	

         A 	 B 	 C 	 D 	 E 	 F 	G 
1	Sun	Mon	Tue	Wed	Thur	Fri	Sat
2		1	2	3	4	5	6
3	7	8	9	10	11	12	13
4	14	15	16	17	18	19	20
5	21	22	23	24	25	26	27
6	28	29	30				
7
8							
9	RD						
10	DT						
					

message edited by DerbyDad03


Reply ↓  Report •

#6
May 30, 2020 at 14:01:59
Hi DerbyDad03. Yes you are correct. I just noticed that the posted data was incorrect. Thank you. I realized that I really don't need a calendar for this worksheet, so yes, I only needed a formula in B10, that if I entered a date in B9, B10 shows a date that falls on a Thursday of the week before, if the date in B9 is a Tuesday. On the other hand, I want B10 to show a date that falls on a Tuesday of the week before, if the date in B9 is a Friday.

Reply ↓  Report •

#7
May 30, 2020 at 18:58:42
Did you try Mike's formula?

message edited by DerbyDad03


Reply ↓  Report •

#8
May 30, 2020 at 19:15:58
Mike's formula worked perfect! I'm not aware of Weekday excel function.

Reply ↓  Report •

Ask Question