Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

urgent please DO THE FOLLOWING IN EXCEL PROVIDE A FORMULA TO ENTER IN CELL E3, TO COUNT ONLY IF MONTH IN COLUMN DATE 1 AND

urgent please

DO THE FOLLOWING IN EXCEL

PROVIDE A FORMULA TO ENTER IN CELL E3, TO COUNT ONLY IF MONTH IN COLUMN DATE 1 AND COLUMN DATE 2 ARE EQUAL.

SO THE FORMULA SHOULD COUNT 1 FOR ROW WITH DATE

1/5/2022 1/12/2022

1 FOR THE ROW:

3/16/2022 3/22/2022

AND 1 AGAIN FOR THE ROW

4/2/2022 4/20/2022

AND IN CELL E3 WE SHOULD SEE A RESULT OF 3 (WHICH IS THE SUM OF THE THREE 1s)

PLEASE DON'T CREATE ANOTHER COLUMN TO PULL THE MONTH SEPARATELY TO COMPARE (I KNOW HOW TO DO THAT), WHAT I AM LOOKING FOR IS GIVE JUST ONE FORMULA THAT SHOWS THE RESULT IN CELL E3, AND PLEASE SHOW A SCREENSHOT OF YOUR RESULT.

image text in transcribed

G8 1 2 3 4 5 167 8 LO 9 10 11 fxx B C DATE 1 DATE 2 1/5/2022 1/12/2022 3/15/2022 12/20/2022 3/16/2022 3/22/2022 4/2/2022 4/20/2022 5/17/2022 7/3/2022 D E COUNT SAME # MONTH

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Financial Macroeconomics And Investment Strategy

Authors: Robert T McGee

1st Edition

1137428394, 978-1137428394

More Books

Students also viewed these Finance questions