Forum Discussion
Solved
Day Formula Help
Hi all, so I have a spreadsheet that has a number of formulas that populate dates for various reasons. My issue lies within 2 sets. One is to calculate from a specific date, 6 days ahead, and t...
Sorry, had it the wrong way around. First formula:
=H157-(WEEKDAY(H157)=6)-(WEEKDAY(H165)=6)
Second formula:
=H165-(WEEKDAY(H165)=6)
Can you provide an example of the formulas you're currently using?
There are a variety of strings include... The 2 formulas below are the start and end formulas for my dates. Let me see if I can upload the document here somehow....
=WORKDAY.INTL(B93,6,1,$A$59:$A$87) =IF(WEEKDAY(H157)=6,H157-1,H157)
=WORKDAY.INTL(B93,8,1,$A$59:$A$87) =IF(WEEKDAY(H165)=6,H165-1,H165)A slightly shorter version of =IF(WEEKDAY(H157)=6,H157-1,H157):
=H157-(WEEKDAY(H157)=6)
Change =IF(WEEKDAY(H165)=6,H165-1,H165) to
=H165-(WEEKDAY(H165)=6)-(WEEKDAY(H157)=6)
- Thank you for the shorter versions. I did plug in the formula to the existing spots, and it's giving the same result. An example is the week of 11/13. For Friday 11/17, my 6th day is 11/29, my 8th day is 12/1, which is a Friday, so that day got backed to Thursday 11/30. This only gives me 1 day between the 2 end dates. So I would need my 6th date to backdate, but only if there is only 1 day between the 2.
Sorry! I am in no way any kind of excel pro at all. I'm lucky to have even gotten my dates to where they are by using some formulas borrowed from another spreadsheet at work.
