Forum Discussion
Day Formula Help
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.Sorry, had it the wrong way around. First formula:
=H157-(WEEKDAY(H157)=6)-(WEEKDAY(H165)=6)
Second formula:
=H165-(WEEKDAY(H165)=6)