Forum Discussion
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 the second calculates 8 days ahead, leaving 2 days between the 2 dates. The issue arises when the 8th day falls on a Friday, it back dates to Thursday, so that would only leave 1 day between the first date and second. Is there a way to input a formula for the 6th day date and if it's only 1 day between the 8th day, for it to backdate one day as well? I apologize if that isn't very clear.
Thank you
Sorry, had it the wrong way around. First formula:
=H157-(WEEKDAY(H157)=6)-(WEEKDAY(H165)=6)
Second formula:
=H165-(WEEKDAY(H165)=6)
9 Replies
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)
