How to find a date (user input) is under DST or not? Timezone is also provided.

[Nikhilgupta]

How to determine whether a date is under DST or not? Provided Date and Timezone is supplied by User.

The system only needs to check whether that date (for that timezone) falls under DST or not?

[kbkumar]

Hi Nikhil - Welcome to the forum.

DST (Daylight Saving Time) for this year started on the 25th March 2012 and ended on 28th October 2012 (this is for UK). Assuming the start date in A2, end date in B2 and your choice of date in cell C2, use the below to find out whether your selected date (from C2) falls under DST or not:

=IF(AND(C2>A2,C2<B2),"Yes","No")

Hope this helps.

[Nikhilgupta]

What I am looking for is:
User enters a date, lets say : 22-Nov -2012
then user enters the Time Zone, lets say: EST
Then macro should tell whether this date for this time zone is under DST or not?

I hope now my question is clear