When you select the compatibility version, does it stick with the workbook if you email it to a coworker? IOW, if I build a workbook with Version 2 - Latest, and then email it out to someone with an older Excel, does it still effectively stay as Version 2?
Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns i.e 20/11/2024 Diner to 24/11/24 Breakfast BF (Column) 4nos Lunch (Column) 3nos Diner (Column) 4nos If you give me a solution i will be very greatful.
Can you show what kind of change there is in the other 4 functions?
When you select the compatibility version, does it stick with the workbook if you email it to a coworker?
IOW, if I build a workbook with Version 2 - Latest, and then email it out to someone with an older Excel, does it still effectively stay as Version 2?
Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns
i.e
20/11/2024 Diner to 24/11/24 Breakfast
BF (Column)
4nos
Lunch (Column)
3nos
Diner (Column)
4nos
If you give me a solution i will be very greatful.
Ask chatgpt