code:

Option Explicit

Private Type SYSTEMTIME
    wYear As Integer
    wMonth As Integer
    wDayOfWeek As Integer
    wDay As Integer
    wHour As Integer
    wMinute As Integer
    wSecond As Integer
    wMilliseconds As Integer
End Type
Private Type TIME_ZONE_INFORMATION
    Bias As Long
    StandardName(0 To 31) As Integer
    StandardDate As SYSTEMTIME
    StandardBias As Long
    DaylightName(0 To 31) As Integer
    DaylightDate As SYSTEMTIME
    DaylightBias As Long
End Type
Private Enum TIME_ZONE
    TIME_ZONE_ID_INVALID = 0
    TIME_ZONE_STANDARD = 1
    TIME_ZONE_DAYLIGHT = 2
End Enum

Private Declare Function GetTimeZoneInformation Lib "kernel32" _
    (lpTimeZoneInformation As TIME_ZONE_INFORMATION) As Long
 
Function GetCurrentTimeEST() As Date
    Dim localDateTime As Date
    Dim GMTDateTime As Date
    Dim ESTDateTime As Date
    
    'Get the current time as usual
    localDateTime = Now()
    
    'Get time zone info
    Dim TZI As TIME_ZONE_INFORMATION
    Dim DST As TIME_ZONE
    
    DST = GetTimeZoneInformation(TZI)

    'TZI.Bias is number of minutes to get back to GMT, then minus 5 hours
    ESTDateTime = localDateTime + TimeSerial(0, TZI.Bias, 0) - TimeSerial(5, 0, 0)
    
    'Return
    GetCurrentTimeEST = ESTDateTime
End Function