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)
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! 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)
- I have plugged both in and they seem to be good...I do need to use both formulas correct? ☺ Just want to be sure
Yes, indeed.
- You are amazing! Thank you so much! Did you learn how to do the formulas on your own or take a class? Excel is still one of those things that I can work around but with a lot of help from Google LOL