i want to make a result for release , when it release on sunday, it will be automatically change to monday. how to make it ?
i want to make a result for release , when it release on sunday, it will be automatically change to monday. how to make it ?
Use this in D2:
=A2+C2+(WEEKDAY(A2+C2)=1)
then copy down.
Hope this helps.
Pete
its very helpful , thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks