Hello Everyone ,
I am the new user in this forum and glad to see every solutions .
I have one Google online spreadsheet where I have one simple formula which shows the no of production days and it is given as below ,
=today()-H6
It calculates the no of days as per the date entered in column (H) . My Problem is that it is counting Saturday and Sunday as well in this formula .
Where we do not work on Weekends . I need the formula in a way that it should not count the weekends in the formula and should show the exact no of days . i.e If I have entered date "03/27/2015" which is Friday then it should not count weekends.
Please help me with this formula .I really appreciate your help in advance .
Bookmarks