Format a date in shortest format possible indicating how many days have passed (Past date)
If date1-date2 < 8 Sat, Fri, …
If date1-date2 < 350 Dec24, Jan4, Aug14
Else 2020Feb4
Excel f(x)s = Excel Functions
Format a date in shortest format possible indicating how many days have passed (Past date)
If date1-date2 < 8 Sat, Fri, …
If date1-date2 < 350 Dec24, Jan4, Aug14
Else 2020Feb4
A technic I loved using, return list of items (up to 12 items now) in ONE number.
Let us say you have list of 12 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for awhile in my archive. I called it 12Return4095