meaning

How do you update a date to current yr. I have a column with 3/1/2018, with the next 5/15/2018 and I need them updated to to 2019. Meaning 3/1/2019, and 5/15/2019

We're moving from Windows 7 Pro to Windows 10 Enterprise. I'd like code in my workbook to work under either environment, meaning I need to determine which environment a user is in and adapt my code accordingly. Thoughts?

Hi I found very interesting function from web. It has been done by some Finnish guy, so some functions are in Finnish. Short translating PYÖRISTÄ.DES.ALAS = ROUNDDOWN PYÖRISTÄ = ROUND JOS = IF EKSPONENTTI = EXP Another Finnish words are cells names ( Name Manager) Link to the this web site...

Hi All, I am trying to make a basic attendance for our school and would like to ask on how do I go about this; If I am to put "L" in a cell (which means Late), it will count or display it as 1 (meaning the student has incurred 1 Late). And if I am to put "LL" (meaning the student incurred two...

I am learning about UDF. So I saw a code as below and I didn't understand operators "><=" in that code Chk = (InStr("><=", Left(FindStr, 1)) > 0) Can I help me to clarify it?

I have the 6 columns that I need to include in an IF formula that I am having issues with. Column A is Ethnicity,Values are "Y" for Yes and "N" for No Column B is America Indian, Values are "0" mean not American Indian and "1" meaning person is America Indian Column C is Asia, Values are "0"...

Hello everyone, I have a series of dates from 2013 till 2018. I'd like to count the exact days for them but they aren't in sequence. Meaning a date could start from 12 march 2013, the next one from 15...etc. <colgroup><col></colgroup><tbody> 08-Jan-13 09-Jan-13 12-Jan-13 15-Jan-13 Many...

=SUM(IF(IF(MATCH(Table1[Ivoice],Table1[Ivoice],0)=ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]]),(ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]])),0)<>0,Table1[Totals],"")) Can someone break this down, and explain this formula to me. I know what it does, but not clear of the meaning...

Dear All Board Members, I need here help to understand in this formula... What is the meaning of this-

Hi Excel masters, I want to restrict cell editing if the date is not "today". Meaning - I have a table like this: And I would like to restrict access to cells so they can only fill the cells of todays date (each date has 3 rows), so they can't edit yesterdays inputs, or make inputs ahead...

Hello Can some one assist in vba code what is the meaning of SpecialCells(2, 1)

Can anyone please tell me what the following line means, and what it does; ReDim lNumbers(1 To lRows * lCols, 1 To 2) Thanks