passed

Hello everyone we are in 2017 year pay 48 months (which is 4 years) the question is how we can write formula in excel that each 12 months pass it is automatically go to another year for example when 12 months passed write 2018 and if 24 months passed write 2019? thanks

I'm trying to set passed arguments directly to an array for ease of use. As an example what I currently do is similar to: Sub Macro1(arg1 As String, arg2 As String, arg3 As String, arg4 As String)Dim args(1 to 4) as String args(1) = arg1 args(2) = arg2 args(3) = arg3 args(4) = arg4 for a = 1 to...

I'm using Excel 2010. This seems like a fairly basic function, but I'm having trouble getting it to work the way I intend. I have a string variable that is being passed through to the body of an email. There are different pieces of information stored in named ranges of the Excel file that...

Hi everyone, Is there a way to change a cell to a value of a formula that was calculated but only for certain cells, and after the date has passed. Here is the formula in a cell that I want to change to just the value : =(COUNTIFS('Decision Tracking'!H:H,A7,'Decision Tracking'!I:I,""))...

Hey all, Love this place of wisdom! May I please have a macro button on the same sheet that says: If start date in cells D10:D100 has passed today's date and end date in cells E10:E100 has also passed today's date, delete values in B10:E100 and G10:I100, then sort column D10:D100 by oldest to...