User Profile
squid2023
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Count number of Years, but not in sequence
I need to count the number of years a person worked. For example in this range of dates, the correct count is 5. What would be the formula? 1/1/1975 3/1/1975 4/1/1976 5/1/1976 2/25/2011 12/15/2013 12/31/2013 6/17/2022 7/31/2022 9/17/2022 TIA MikeSolved323Views0likes1CommentCustom Function - LET or LAMDA?
I have a custom function to sum based upon interior color of a cell that works. Can this formula be mimicked by using LET or LAMBDA? If so.. how? Function ColorSum(myrange As Range, mycolorindex As Integer) As Double Dim c As Range On Error Resume Next For Each c In myrange.Cells If c.Interior.ColorIndex = mycolorindex Then _ ColorSum = ColorSum + c.Value Next End Function587Views0likes2Comments