LinkBack URL
About LinkBacks
hi guys . i need some help.. how to remove apostrophe in the formula..
=NETWORKDAYS(L66,N66,'Ref Table'!'M366':'M486')-1
it should be
=NETWORKDAYS(L66,N66,'Ref Table'!M366:'M486)-1
my code is
Please Login or Register to view this content.
.Thank You
remove apostrophe in the formula
hi guys . i need some help.. how to remove apostrophe in the formula..
=NETWORKDAYS(L66,N66,'Ref Table'!'M366':'M486')-1
it should be
=NETWORKDAYS(L66,N66,'Ref Table'!M366:'M486)-1
my code is
Please Login or Register to view this content.
.Thank You
Last edited by kielle; 12-13-2016 at 10:50 PM.
You cannot mix the xlA1 syntax with xlR1C1 syntax :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thank You
You are welcome.
Don't forget to mark the thread as solved :
select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks