Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to use workday function and also list the dates automatically?
i.e. a1 = 5/1 b2= all working days until the last working day of the month. (Friday) I have seen a formula that does this: =if(a1="","",if(month(a1+1=month(a$1),a1+1,"")) but not with the workday function. It is not automatic and has to be dragged over. I am not sure if this is possible, or I just don't know what order to put them in. I would like it to fill the working days automatically by entering the date for one cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) |