| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 24403 | 2002-09-10 09:11:00 | Excel Formula help | flying_green_leprachaun (1767) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 78200 | 2002-09-10 09:11:00 | =DAYS360(IF(B3="",$C$2,B3),IF(D3="",$C$2,D3),FALSE) I am trying to figure out how to get the formula only to refer to the 5 working day week. The C2 field has todays date & the B column has a date in it that the item was recieved... Oh heck.... Working Week spreadsheet (homepages.visp.co.nz Week.xls) have a look directly... I have gone brain dead on how to get it to refer to the number of working days in the outstanding column |
flying_green_leprachaun (1767) | ||
| 78201 | 2002-09-10 09:29:00 | NETWORKDAYS will calculate the number of working days, does that help? | godfather (25) | ||
| 78202 | 2002-09-10 09:54:00 | Hi FGL, yes Godfather is correct - the NetWorkDays function can calculate weekdays. However its not installed by default and is an addin. If you dont have this function then select Tools-Addins and select the Analysis Toolpak and insert your Office CD. cheers parry |
parry (27) | ||
| 78203 | 2002-09-10 10:01:00 | Thanks, I was just working on the Formula :-) Much appreciated Godfather & Parry... A little reminder is always good. | flying_green_leprachaun (1767) | ||
| 1 | |||||