I am trying to set up a spread sheet where dates are automatically calculated from the previous date using the formula Cell address + 1 (e.g. =Sum(a1+1) but I want to restrict it to the working week. The formula should say something like "=SUM (A1+1 if A1= Monday, Tuesday, Wednesday or Thursday but if A1 = Friday then A1 +3)"
I probably haven't explained that very well, but if anyone can help I would be grateful
Here, try his:
=A1+IF(WEEKDAY(A1,2)<5,1,3)
"Relax. What is mind? No matter. What is matter? Never mind!"
Perhaps =IF(weekday(a1,2)<5,a1+1,a1+3)
Cheers - THE WARNING I RECEIVED WAS NOT JUSTIFIED
Fantastic - that works brilliantly - many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks