How to add required no.of days to a date consider a count in Excel? -


i have start date , count of files.now end should depends on count. example, have 40 files executed , start date 01-jul-17, end should committed considering 40. if condition exceeds more 20 date should added 1. result should 02-jul-17.

in a1 cell

01-jul-17 

in b1 cell

25 

in c1 cell

=if(b1>20,a1+1,a1) 

or

=if(b1>20,workday(a1,1),a1) 

to take care of weekly holidays.


Comments

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

Python Tornado package error when running server -

Qt QGraphicsScene is not accessable from QGraphicsView (on Qt 5.6.1) -