I like your examples. Thanks for posting.

Your video is very helpful but I need help to find a Date between a range of dates I try to find out if a date in my list occurs during DST (Daylight saving time) or Standard time I need to calculate a time for an event in my spreadsheet and if the date will be during DST (Daylight saving time) they have to add 7 Hours if it falls during winter time that use standard time it should only add 6 hours So I have a list with 50 events during 10 year periods so I need to find out on every date if its durned DST or Standard time for that year I do have a table with the dates for DST start/end from 2014 to 2033

Thanks!

@ExcelDestination

2 жыл бұрын

Welcome

Can you explain me how to calculate difference between same date like that 01-01-2023 to 01-01-2023 it's different count 1 how to do this

I have a list of dates when a specific event took place . Now I want to being the date from this list that falls between these two dates

I required more..This is only 1 condition,agar esi case me 5 condition check krna hoto. Agar 3 date hai under to 8 agar 3 date other hai to 7 like this

Bro even after freezing formula is not applying for the rest of the data

Really nice 👌 😍💋 💝💖❤️

@ExcelDestination

3 жыл бұрын

Thanks 🤗

you have 3 late fees