Calculation for Job Employement

N

Newbienew

Active Member
Joined
Mar 17, 2017
Messages
376
Office Version
  1. 2016
Platform
  1. Windows
I am trying to do something that seems simple in theory but rather hard to accomplish in excel. I am trying to calculated the time of age based on current date and birthday minus the time a person was employed with the organization. I know this is simple math on paper but challenging for me in excel
The first portion is the manual entry cells.

<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { text-align: center; border: 0.5pt solid windowtext; }.xl69 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; }</style>
AB CDE
2Today's date>>>> 2017625< USING THE NOW FORMULA FOR EACH CELL
3Birth Day 19861129
 MANUAL
4Hired date 2012612 MANUAL
5Last Word day 2017611 MANUAL
6Years Employed 500 MANUAL
7IRR MANUAL

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:4827;width:99pt" width="132"> <col style="mso-width-source:userset;mso-width-alt:1974;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:1792;width:37pt" width="49"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:6582;width:135pt" width="180"> </colgroup><tbody>
</tbody>

In the second/third part. Over all its simple subtraction. With any calculating dates, if the date on top is less than the one on the bottom than time has to be added. Seeing how I am taking 30 days from "J17" to make of that time. If not less than it will be just the number. Cell "J17" is suppose to say 6, one year is to be taken off "I17" making it 17 because of the 1 = 30 days moved over. I just want this to work as simple as it does on paper.
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { border: 0.5pt solid windowtext; background: rgb(146, 208, 80) none repeat scroll 0% 0%; }.xl69 { font-size: 14pt; font-weight: 700; text-align: center; }.xl70 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl71 { white-space: normal; }.xl72 { font-size: 9pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl73 { font-size: 9pt; white-space: normal; }.xl74 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl75 { font-size: 8pt; white-space: nowrap; }.xl76 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl77 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl78 { font-size: 14pt; font-weight: 700; text-align: center; white-space: normal; }</style>
IJK
TODAY'S DATE1720171755
BIRTHDAY
1819861129
MINUSED1931627
PLUS 1 FOR THE DAY20 27
SUM TOTAL2130627
MINUS YEARS EMPLOYED
225
00
25
6
27

<colgroup><col style="mso-width-source:userset;mso-width-alt:6582;width:135pt" width="180"> <col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:1974; width:41pt" width="54" span="3"> </colgroup><tbody>
</tbody>
Formula breakdown.
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { border: 0.5pt solid windowtext; background: rgb(146, 208, 80) none repeat scroll 0% 0%; }.xl69 { font-size: 14pt; font-weight: 700; text-align: center; }.xl70 { font-size: 8pt; white-space: nowrap; }.xl71 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl72 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl73 { font-size: 14pt; font-weight: 700; text-align: center; white-space: normal; }</style>
IJK
17=IF(L17<L18,D2-1,D2)=IF(M17>M18,E2-1,E2)+IF(E3>E2,12,E2)=IF(F2<M18,F2+30,F2)
18=D3=E3=F3
19=K17-D3=+L17-E3=M17-F3
20 =M19+1
21=IF(L21>L22,K19-1,K19)=IF(M21<M22,L19-1,L19)=IF(M22>M20,M20+30,M20)
22=D6=E6=F6
=K21-D6=L21-L22=M21-M22

<colgroup><col style="mso-width-source:userset;mso-width-alt:1865;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:2742;width:113pt" width="150"> <col style="mso-width-source:userset;mso-width-alt:4534;width:186pt" width="248"> <col style="mso-width-source:userset;mso-width-alt:3291;width:135pt" width="180"> </colgroup><tbody>
</tbody>





Part Three, this is going to be similar to what is above.
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { border: 0.5pt solid windowtext; background: rgb(146, 208, 80) none repeat scroll 0% 0%; }.xl69 { font-size: 14pt; font-weight: 700; text-align: center; }</style>
BCD
Date of Tenure172017525
182012612
195-113

<colgroup><col style="mso-width-source:userset;mso-width-alt:4827;width:99pt" width="132"> <col style="mso-width-source:userset;mso-width-alt:1974;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:1792;width:37pt" width="49"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> </colgroup><tbody>
</tbody>

Formula Breakdown
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { border: 0.5pt solid windowtext; background: rgb(146, 208, 80) none repeat scroll 0% 0%; }.xl69 { font-size: 14pt; font-weight: 700; text-align: center; }</style>
BCD
17=D2=IF(F17>F18,E2-1,E2)=IF(F2<F18,F2+30,F2)
18=D4=E4=F4
19=D17-D18=+E17-E18=+F17-F18+COUNTA(D7)

<colgroup><col style="mso-width-source:userset;mso-width-alt:1974;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:3218;width:132pt" width="176"> <col style="mso-width-source:userset;mso-width-alt:2486;width:102pt" width="136"> <col style="mso-width-source:userset;mso-width-alt:2889;width:119pt" width="158"> </colgroup><tbody>
</tbody>


I am sorry for the detailed break down or trying to explain it all. Don't meany any disrespect by my explanation.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
your required time of age is in B7 and converted in yr, month and day in Row 8


Excel 2012
ABCD
1Today2017626
2Birthday19861129
3Hired date2012612
4Last Work day2017611
5Years Employed5.0
6
7Time of age25.6
825628
Sheet3
Cell Formulas
RangeFormula
B1=YEAR(TODAY())
B5=(DATE(B4,C4,D4)-DATE(B3,C3,D3))/365.25
B7=(DATE(B1,C1,D1)-DATE(B2,C2,D2))/365.25-B5
B8=INT((DATE(B1,C1,D1)-DATE(B2,C2,D2))/365.25-B5)
C1=MONTH(TODAY())
C8=INT(((DATE(B1,C1,D1)-DATE(B2,C2,D2))/365.25-B5-B8)*12)
D1=DAY(TODAY())
D8=((DATE(B1,C1,D1)-DATE(B2,C2,D2))/365.25-B5)*365.25-(B8+C8/12)*365.25
 
Upvote 0
@AlanY First thank you much for your help. I did the calculation by hand I got 26 years 6 months 28 days. I believe I messed up on my post entry. I put 31 and didn't move it down. Making it 30 instead. lol Sorry about that. If I plug what you posted in row 23 "which i didn't label" this will work the same way or will i have to change everything to match those columns and rows. I want to be sure as that is how the sheet is built. And how can i do this for the 3 part. Where its todays date minus dated hired. Respectfully and thank you again
 
Upvote 0
you mean like this?


Excel 2012
ABCD
1
2Today2017627
3Birthday19861129
4Hired date2012612
5Last Work day2017611
6Years Employed5.0
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23Time of age25629
Sheet1
Cell Formulas
RangeFormula
B6=(DATE(B5,C5,D5)-DATE(B4,C4,D4))/365.25
B23=INT((DATE(B2,C2,D2)-DATE(B3,C3,D3))/365.25-B6)
C23=INT(((DATE(B2,C2,D2)-DATE(B3,C3,D3))/365.25-B6-B23)*12)
D23=((DATE(B2,C2,D2)-DATE(B3,C3,D3))/365.25-B6)*365.25-(B23+C23/12)*365.25
 
Upvote 0
The first section is separate from the other parts. I am trying to put the formula in the sections according to how the sheet is built already. The first part is the manual entry portion. They just chance the Years employed to Total Time Employed.
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { font-weight: 700; text-align: center; border: 0.5pt solid windowtext; }.xl69 { text-align: center; border-width: 0.5pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: windowtext currentcolor windowtext windowtext; }.xl70 { text-align: center; border-width: 0.5pt medium; border-style: solid none; border-color: windowtext currentcolor; }.xl71 { text-align: center; border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentcolor; }.xl72 { border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }.xl73 { border: 0.5pt solid windowtext; background: rgb(112, 48, 160) none repeat scroll 0% 0%; }</style>
A1BCDEF
2Today's date>>>>2017628
3Birth Day19861129
4Hired date2012612
5Last Word day2017611
6Total Time Employed533
7IRR

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:6582;width:135pt" width="180"> </colgroup><tbody>
</tbody>


Below is a section to itself and the red part is where I am trying to place your formula to work in.

<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { font-size: 14pt; font-weight: 700; text-align: center; }.xl69 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl70 { font-size: 9pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl71 { font-size: 9pt; white-space: normal; }.xl72 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl73 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl74 { font-size: 14pt; font-weight: 700; text-align: center; white-space: normal; }.xl75 { border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }.xl76 { border: 0.5pt solid windowtext; background: red none repeat scroll 0% 0%; }.xl77 { font-size: 14pt; font-weight: 700; text-align: center; white-space: nowrap; }.xl78 { white-space: normal; }.xl79 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }</style>
I16JKL
TODAY'S DATE1720171758
BIRTHDAY1819861129
MINUSED1931629
PLUS 1 FOR THE DAY20 30
SUM TOTAL2131630
MINUS YEARS EMPLOYED22533
Total2326327

<colgroup><col style="mso-width-source:userset;mso-width-alt:6582;width:135pt" width="180"> <col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> </colgroup><tbody>
</tbody>



This last section I am also trying to do the same thing but only with Todays date and Date Hired. If there is any IRR time its Plus one for the day, but I believe that could be a CountA or countblank for C7 formula added to the day cell. <style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { text-align: center; border-width: medium medium medium 0.5pt; border-style: none none none solid; border-color: currentcolor currentcolor currentcolor windowtext; }.xl69 { border: 0.5pt solid windowtext; background: red none repeat scroll 0% 0%; }</style>
Todays date2017528
Date Hired2012612
total5-116If IRR time +1 for the day

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> </colgroup><tbody>
</tbody>

I dont know why other areas have color markings, birthday, 17-21 and the blank red at the top. But your formula works amazing i just cant get it to work for me when moving it. I spent have the workday trying to figure it out. I didn't wnat to post again trying to be prideful. I want to say thank you again for you help
 
Upvote 0
see if this is what you're after


Excel 2012
ABCDIJKL
1
2Today2017629
3Birthday19861129
4Hired date2012612
5Last Work day2017611
6
7
8
9
10
11
12
13
14
15
16
17TODAY'S DATE2017629
18BIRTHDAY19861129
19MINUSED30630
20PLUS 1 FOR THE DAY30
21SUM TOTAL30660
22MINUS YEARS EMPLOYED41129
23Total25629
Sheet2
Cell Formulas
RangeFormula
J19=INT((DATE(J17,K17,L17)-DATE(J18,K18,L18))/365.25)
J22=INT((DATE(B5,C5,D5)-DATE(B4,C4,D4))/365.25)
J23=INT((DATE(J19,K19,L19)-DATE(J22,K22,L22))/365.25)
K19=INT(((DATE(J17,K17,L17)-DATE(J18,K18,L18))/365.25-J19)*12)
K22=INT(((DATE(B5,C5,D5)-DATE(B4,C4,D4))/365.25-J22)*12)
K23=INT(((DATE(J19,K19,L19)-DATE(J22,K22,L22))/365.25-J23)*12)
L19=((DATE(J17,K17,L17)-DATE(J18,K18,L18))/365.25)*365.25-(J19+K19/12)*365.25
L22=((DATE(B5,C5,D5)-DATE(B4,C4,D4))/365.25-(J22+K22/12))*365.25
L23=((DATE(J19,K19,L19)-DATE(J22,K22,L22))/365.25)*365.25-(J23+K23/12)*365.25
 
Upvote 0
This is what i got when i cut and pasted. <style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { font-size: 14pt; font-weight: 700; text-align: center; }.xl69 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl70 { font-size: 9pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl71 { font-size: 9pt; white-space: normal; }.xl72 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl73 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl74 { font-size: 14pt; font-weight: 700; text-align: center; white-space: normal; }.xl75 { border: 0.5pt solid windowtext; background: red none repeat scroll 0% 0%; }.xl76 { font-size: 14pt; font-weight: 700; text-align: center; white-space: nowrap; }.xl77 { white-space: normal; }.xl78 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl79 { border: 0.5pt solid windowtext; background: red none repeat scroll 0% 0%; }</style>
I16JKL
TODAY'S DATE172016630
BIRTHDAY1819861129
MINUSED TOTAL192970.6875
PLUS 1 FOR THE DAY20 1.6875
SUM TOTAL212971.6875
MINUS YEARS EMPLOYED22533
Total2324
3
27.6875

<colgroup><col style="mso-width-source:userset;mso-width-alt:6582;width:135pt" width="180"> <col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> </colgroup><tbody>
</tbody>

If i do it by hand this is what i got based off todays day

<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { border: 0.5pt solid windowtext; }.xl68 { font-size: 14pt; font-weight: 700; text-align: center; }.xl69 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl70 { font-size: 9pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl71 { font-size: 9pt; white-space: normal; }.xl72 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }.xl73 { font-size: 14pt; font-weight: 700; text-align: center; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: normal; }.xl74 { font-size: 14pt; font-weight: 700; text-align: center; white-space: normal; }.xl75 { font-size: 14pt; font-weight: 700; text-align: center; white-space: nowrap; }.xl76 { white-space: normal; }.xl77 { font-size: 8pt; border-width: medium 0.5pt medium medium; border-style: none solid none none; border-color: currentcolor windowtext currentcolor currentcolor; white-space: nowrap; }</style>
I16JKL
TODAY'S DATE1720161830
BIRTHDAY1819861129
MINUSED1930
7
1
PLUS 1 FOR THE DAY20 2
SUM TOTAL2130632
MINUS YEARS EMPLOYED22533
Total2325
329

<colgroup><col style="mso-width-source:userset;mso-width-alt:6582;width:135pt" width="180"> <col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> </colgroup><tbody>
</tbody>

I am not sure what happened
 
Upvote 0
Hello, I am revisiting this posting I made in need of some assistance as it has resurfaced in my workering tickler. Mr. AlanY provide some outstanding assistance and aid. I did happen to use what was provided but I had an issue with getting ti to work fully. I am greatly appreciative for the additional assistance. If you could have any questions please let me know.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
864
gvsumich
G
E
  • Question
Adding a custom message.
Replies
1
Views
462
Micron
M
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
341
VBAEXCELNew
V
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,216,075
Messages
6,128,667
Members
449,462
Latest member
Chislobog

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top