Need Help: Count based on 2 Different in VBA (Dates in Indian Date Format)

[Mahantesh_Torgal]

Hi Excel Masters,

I need to count few items in Different column(Eg. Column A) based on start & end Date(column B).

However , dates are in Indian Date Format (01-Jan-2018).

Attached is the sample file.

E.g: If 'Lenovo T450' , i want to count them between '01-May-2018' & '21-May-2018' in VBA.

I tried but Date is coming as US Format (5/1/2018) & (5/21/2018) in code which i want in INDIAN Date format.

Can any one please help. Please check below data and let me know result.

I Need DATES IN INDIAN DATE Format only

Assigned Date	Laptop Model
18-Mar-16	Lenovo T450
18-Mar-16	Lenovo T450
10-Jun-16	Lenovo T450
18-Mar-16	Lenovo T450
18-Mar-16	Lenovo T450
5-Mar-16	Lenovo T440
18-Mar-16	Lenovo T450
17-Mar-16	Lenovo T450
18-Mar-16	Lenovo T440
15-Apr-16	Lenovo T450
11-Apr-16	Lenovo T450
22-Apr-16	Lenovo T450
1-Sep-16	Lenovo T450
22-Mar-16	Lenovo T440
15-Mar-16	Lenovo T450
11-Aug-16	Lenovo T450
14-Mar-16	Lenovo T450
19-May-16	Lenovo T440
15-Mar-16	Lenovo T450
4-Oct-16	Lenovo T450
15-Mar-16	Lenovo T450
2-Aug-16	Lenovo T450
4-Apr-16	Lenovo T450
4-Apr-16	Lenovo T450
6-May-16	Lenovo T450
6-May-16	Lenovo T450

<colgroup><col><col></colgroup><tbody>
</tbody>

Regards,
Mahantesh

 

[mse330]

Can you show us your VBA code ? I don't see any "2018" in your sample data ...

 

[Mahantesh_Torgal]

Can you show us your VBA code ? I don't see any "2018" in your sample data ...

Hi Mate,

Forget the date 2018.

take the example dates 01-Mar-2016 to 31-Mar-2016.

Regards,
Mahantesh

 

[mse330]

Please show us your VBA code & where/what error message you get? Can you simply change the format similar to the below code

Sub test()

Dim dDate As Date
dDate = "31-May-18" ' "31-May-18" = #5/31/2018#

Debug.Print Format(dDate, "dd-mmm-yyyy")

End Sub