Format column to calculate network days
Closed
drush72
-
12 Nov 2009 à 17:27
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 17 Nov 2009 à 15:40
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 17 Nov 2009 à 15:40
Related:
- Format column to calculate network days
- Network card - Guide
- Wifi network - Guide
- Wireless network watcher - Download - Other
- Dvi format - Guide
- Wpan network - Guide
3 responses
Thanks for your help. Here is the formula
=NETWORKDAYS(I75,K75,{39814;39860;39958;39998;40063;40143;40144;40172})-1
=NETWORKDAYS(I75,K75,{39814;39860;39958;39998;40063;40143;40144;40172})-1
sharpman
Posts
1021
Registration date
Saturday 23 May 2009
Status
Contributor
Last seen
20 October 2010
183
15 Nov 2009 à 14:25
15 Nov 2009 à 14:25
could you please supply the formula that you are using, i will have a look and make adjustments as necessary.
what you need to do is write the formula along the lines on only action the cell if there is an entry in the cell otherwise make it blank.
I could explain better if I saw what the formula was that you are using.
what you need to do is write the formula along the lines on only action the cell if there is an entry in the cell otherwise make it blank.
I could explain better if I saw what the formula was that you are using.
Works great, thank you for your help.
sharpman
Posts
1021
Registration date
Saturday 23 May 2009
Status
Contributor
Last seen
20 October 2010
183
17 Nov 2009 à 15:40
17 Nov 2009 à 15:40
your welcome.
16 Nov 2009 à 16:10
=IF(ISBLANK(K75)," ",NETWORKDAYS(I75,K75,DATEVALUE({"24/12/09","25/12/09"})))
put your dates between the brackets enclosed in " and separated by commas. sooo much easier to read the formula rather than having to decipher the date serial numbers for the holidays.
The isblank cell reference can be either I75,or K75, it makes no odds as when the cell referenced is empty it will not action the formula just leave a blank cell.
Hope that was helpful for your purposes.