What will be the date after 3 months form now?

What will be the date after 3 months form now?

=EDATE(date, number of months)

Excel's new ew artificial intelligence (AI) features explained by Microsoft.

New tools (Ideas), new data types and new fuctions added Excel to provide artificial intelligence (AI) features. 

These functions:  FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, SINGLE, and RANDARRAY.

More information:  https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/bringing-ai-to-excel-4-new-features-announced-today-at-ignite/

Excel in business life

https://www.facebook.com/EngineeringML/photos/pb.1701212786658447.-2207520000.1564390695./2251719211607799/?type=3&theater

Create a chart by pressing F11 key

To change a formula

There are different ways to change a formula; 

1) On formula bar. 

2) Doubl-click on the cell

3) Press F2 key

Usage of Percent Sign %

Percent sign are used for different purposes.

Excel VBA - Find the last row

In Excel VBA, we need to find out last row number (how many rows / data tables's rows count) to scroll down or other operations.

For example start from B2 to the last row in B column.

Sheets("FC").Range("b2").End(xlDown).Row

or

Sheets(1).Range("b2").End(xlDown).Row

Example: Read all row in the column and add to combo box.

For line= 2 To wb1.Sheets(1).Range("b2").End(xlDown).Row

ThisWorkbook.Sheets("Sheet1").ComboBox1.AddItem wb1.Sheets(1).Cells(satir, 2).Value

Next