Workday Help

[samitnair]

Hello

I need to generate a list (A1:A23) of working days (excluding weekdays) for the current month. I am currently using =WORKDAY(startdate,1,) with the startdate reference is in F1, but in that situation the A1 starts with the second working day. example: if I put 1 November 2017, Wednesday in cell F1 the list starts with 2 November 2017, Thursday. Please help

 

[Joe4]

How about:
=WORKDAY(startdate-1,1)

 

[samitnair]

How about:
=WORKDAY(startdate-1,1)

Hello Joe,

That definitely did the trick but if I may ask, once i drag down the list goes beyond this month. Can we restrict the formula from not going beyond the startdate and end date specified in cell F1 and F2.

Also i had a doubt when we add this date list to a new chart it still shows saturday sundays? Is it a limitation or am I doing something wrong

Thanks

 

[Joe4]

What is the exact formula you are dragging down?
If you are using a named range of "startdate" and are hard-coding in the days you are adding, like shown:

[COLOR=#333333]=WORKDAY(startdate-1,1)[/COLOR]

the value would never change when dragging down.

So, I am guessing that you must have made some modification to your formula (other than the one that was posted).

 

[samitnair]

What is the exact formula you are dragging down?
If you are using a named range of "startdate" and are hard-coding in the days you are adding, like shown:

[COLOR=#333333]=WORKDAY(startdate-1,1)[/COLOR]

the value would never change when dragging down.

So, I am guessing that you must have made some modification to your formula (other than the one that was posted).

I have not created a named list. I have a start date of the current month in a cell F1


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]=WORKDAY(F1-1,1)[/TD]
[TD][/TD]
[TD]01 October 2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]=WORKDAY(A1,1)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]=WORKDAY(A2,1)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Regards

 

[Joe4]

If you have an end date in cell F2, then if you put this formula in cell A2 and copy down, it will stop at your end date (it will show all blanks after that):

=IFERROR(IF(WORKDAY(A1,1)<=$F$2,WORKDAY(A1,1),""),"")

 

[samitnair]

If you have an end date in cell F2, then if you put this formula in cell A2 and copy down, it will stop at your end date (it will show all blanks after that):

=IFERROR(IF(WORKDAY(A1,1)<=$F$2,WORKDAY(A1,1),""),"")

Yes, your suggestion was helpful. I appreciate your help