answer to first question is yes
to the 2nd question
i have an idea to use either Weekday() formula in conjunction with deducting end date with start date of following line but i am unsure of syntax that will align with what you want
Can you clarify how you want to skip the weekend?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi, sorry bit late for a reply.. Did you manage to be able to adjust the formula on my previous sheet to ignore weekends. I just need it to ignore the Saturday and Sundays that pop up so it treats any date on a friday or monday as linked. Regards
Hi, sorry bit late for a reply.. Did you manage to be able to adjust the formula on my previous sheet to ignore weekends. I just need it to ignore the Saturday and Sundays that pop up so it treats any date on a friday or monday as linked. RegardsOriginally Posted by humdingaling
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks