Good Morning
I am hoping someone can help as I am a little stuck
I am trying to calculate a date range of when UTC is applicable. Essentially in the UK this is from the Last Sunday in March through to the Last Sunday in October every year.
I have worked out that the following formula in excel
give me the last Sunday in March if Cell I3 is say 1/3/2020
is their a simple way of converting
to VBA to say strStartDate = "FLOOR(EOMONTH(" & format("1/3/2020","dd-mm-yy") & ",0)-1,7)+1" , strEndDate = "FLOOR(EOMONTH(" & format("1/10/2020","dd-mm-yy") & ",0)-1,7)+1"
I hope this makes since as to what I am trying to do and someone can help
regards
I am hoping someone can help as I am a little stuck
I am trying to calculate a date range of when UTC is applicable. Essentially in the UK this is from the Last Sunday in March through to the Last Sunday in October every year.
I have worked out that the following formula in excel
Excel Formula:
FLOOR(EOMONTH(I3,0)-1,7)+1
is their a simple way of converting
Excel Formula:
FLOOR(EOMONTH(I3,0)-1,7)+1
I hope this makes since as to what I am trying to do and someone can help
regards