Trending in Formulas and Functions
CountIF won't recognise the result of a formula
I have a column that contains a column formula driven from a date. GRID COLUMNS Detection Date = DD/MM/YY Year = formula: =20 + RIGHT([Detection Date]@row, 2). Result = 2023 Sheet summary This Year = formula: =20 + RIGHT(TODAY(), 2). Result today = 2023 Breach This Year = formula: =COUNTIF(Year:Year, [This Year]#). Result…
Month, Year Calculation Formula
For example if I get Month, Year Value as (1, 2023) i,e Jan 2023 using =MONTH(TODAY()) - 11 + ", " + YEAR(TODAY()) formula what is the formula we have to use to get Previous Month, Year Value (12, 2022) i,e Dec 2022.
How To create a revenue summary formula
How can I create a formula where by I have rows containing different projects, their value and the dates they will start and end and create a summary to show in what months will generate what value (assuming the value is divided equally over however many months the project spans) i.e. Row 1 is Project X with a value of…