Certificates!
Member
I have a formula which works - with the aid of a "Helper Column" which is currently hidden.
The formula I use is: IF(TODAY()>=Q6,Q3-Q6,MIN(365,IF(Q4<=Q3,Q3-Q4,Q3-Q6)))
Q5 = Today.
What this does is count the number of days to the year end (30 Sept 2022) yet stopping at the end of each month. Thus if one were to look at the July monthly worksheet today it would say 61 days in P5
The August sheet will stop counting down after 31st August and say 30 days in P5
I could really do with unhiding column Q for other things in the worksheets. Is there a better way to do what I want to do?
The formula I use is: IF(TODAY()>=Q6,Q3-Q6,MIN(365,IF(Q4<=Q3,Q3-Q4,Q3-Q6)))
Q5 = Today.
What this does is count the number of days to the year end (30 Sept 2022) yet stopping at the end of each month. Thus if one were to look at the July monthly worksheet today it would say 61 days in P5
The August sheet will stop counting down after 31st August and say 30 days in P5
I could really do with unhiding column Q for other things in the worksheets. Is there a better way to do what I want to do?