I have a report that usually covers a full year (1 Jan to 31 Dec). Sometimes it may start or end at dates other than these two, so my header would change to "period" instead of "year".
A difference between the two, gives 365 in leap years and 364 in normal years, so that is not a useful test.
What can I use to get Excel to recognise that 1 Jan to 31 Dec is a full year, anything else is not?
A difference between the two, gives 365 in leap years and 364 in normal years, so that is not a useful test.
What can I use to get Excel to recognise that 1 Jan to 31 Dec is a full year, anything else is not?