Today Function to Extract Data?

[ttop1010]

Hey guys,

I know this is simple but... I want to have a separate cell that tells me what % is for the day.

Again i know this is simple but for some reason I'm drawing blanks.....



B C D E[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 268"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]
28-Jan-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]SUN[/TD]
[TD]7[/TD]
[TD]5.74%[/TD]
[/TR]
[TR]
[TD][TABLE="width: 268"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29-Jan-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 268"]
<tbody>[TR]
[TD]MON[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8[/TD]
[TD]6.56%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Re: Help! Today Function to Extract Data?

This?

Excel 2010
	N	O	P	Q
11	KEY DATES
12	DATE		DAY #	%
13	21-Feb-18	WED	31	25.41%
14	23-Mar-18	FRI	61	50.00%
15	23-Apr-18	MON	92	75.41%
16	23-May-18	SAT	122	100.00%
AVAIL %

Cell Formulas
Range	Formula
N13	=B36
P13	=MATCH(N13,$B$6:$B$127,0)
Q13	=VLOOKUP(P13,$D$6:$E$127,2,0)

(the formulas can be reversed to grab the dates from the days instead)

 

[ttop1010]

Re: Help! Today Function to Extract Data?

This?

Excel 2010

	N	O	P	Q

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: center"]KEY DATES[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]DATE[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DAY #[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]%[/TD]

[TD="align: center"]13[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]21-Feb-18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]WED[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]31[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]25.41%[/TD]

[TD="align: center"]14[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]23-Mar-18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]FRI[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]61[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]50.00%[/TD]

[TD="align: center"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]23-Apr-18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]MON[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]92[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]75.41%[/TD]

[TD="align: center"]16[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]23-May-18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]SAT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]122[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]100.00%[/TD]

</tbody>

AVAIL %​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N13[/TH]
[TD="align: left"]=B36[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P13[/TH]
[TD="align: left"]=MATCH(N13,$B$6:$B$127,0)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q13[/TH]
[TD="align: left"]=VLOOKUP(P13,$D$6:$E$127,2,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



(the formulas can be reversed to grab the dates from the days instead)

thank you for the reply


i think what Im looking to do is have the DATE / CURRENT % relative that date showing in another column so when the user opens, it immediately auto populates the current date and the % associated with it.

i hope this helps. thanks again for the reply

 

[sheetspread]

Re: Help! Today Function to Extract Data?

This?

Excel 2010
	AH	AI
12	15-Mar-18	43.44%
AVAIL %

Cell Formulas
Range	Formula
AH12	=TODAY()
AI12	=VLOOKUP(AH12,$B$6:$E$127,4,0)

 

[ttop1010]

Re: Help! Today Function to Extract Data?

It worked, thank you so much!