Display Data For Today's Date

Camilla1980

New Member
Joined
Mar 22, 2018
Messages
13
Hi there,

I was wondering if someone could offer a novice a helping hand?

I'm pulling together a dashboard to display, amongst other things, the cumulative daily % variance of actual v target.

I have the days of the month in A2-A33 and the actual cumulative +/- % in F2-F33.

The only thing I want to display on the dashboard is the daily cumulative % as of that day (from column F) and this would be shown in H2.

Any help would be really appreciated!

Thanks in advance

Camilla
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,865
Office Version
365
Platform
Windows
Something like
=INDEX(Sheet1!F2:F33,MATCH(TODAY(),Sheet1!A2:A33,0))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,865
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,089,953
Messages
5,411,480
Members
403,374
Latest member
PMMHart

This Week's Hot Topics

Top