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

[TABLE="width: 238"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Assigned Date[/TD]
[TD]Laptop Model[/TD]
[/TR]
[TR]
[TD]18-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]18-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]10-Jun-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]18-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]18-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]5-Mar-16[/TD]
[TD]Lenovo T440[/TD]
[/TR]
[TR]
[TD]18-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]17-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]18-Mar-16[/TD]
[TD]Lenovo T440[/TD]
[/TR]
[TR]
[TD]15-Apr-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]11-Apr-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]22-Apr-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]1-Sep-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]22-Mar-16[/TD]
[TD]Lenovo T440[/TD]
[/TR]
[TR]
[TD]15-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]11-Aug-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]14-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]19-May-16[/TD]
[TD]Lenovo T440[/TD]
[/TR]
[TR]
[TD]15-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]4-Oct-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]15-Mar-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]2-Aug-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]4-Apr-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]4-Apr-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]6-May-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
[TR]
[TD]6-May-16[/TD]
[TD]Lenovo T450[/TD]
[/TR]
</tbody>[/TABLE]

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