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]

 

[ttop1010]

Re: Help! Today Function to Extract Data?

also, it doesnt look like my format worked., the BCDE is the columns, sorry for the confusion

 

[sheetspread]

Re: Help! Today Function to Extract Data?

% of what?

 

[Joe4]

Re: Help! Today Function to Extract Data?

Where are these percentages coming from?
Is there some sort of lookup table?
If so, have look here: https://www.techonthenet.com/excel/formulas/vlookup.php

 

[ttop1010]

Re: Help! Today Function to Extract Data?

Thanks for the quick reply, the % are based off a formula inside the column. Just need a way to relay that into another cell based off the current date.

 

[Joe4]

Re: Help! Today Function to Extract Data?

Can you please post the formula, and explain any details that we need to know to understand how it works?

 

[ttop1010]

Re: Help! Today Function to Extract Data?

This sheet is used to give our Projects Managers an accurate idea where we should be % on our project

this project is 1/22/18 thru 5/23/18

the formula below give us the %

=D6/$D$127

i have 4 columns

B- DATE
C- DAY(MON)
D- DAY # (BASED OFF HOW MANY DAYS IN THE PROJECT)
E- % COLUMN. How far along we should be in the project based off the allotted time

hope this helps

 

[Joe4]

Re: Help! Today Function to Extract Data?

So what is in D6 and D127?

It might be best to post an actual data example, and show your expected results, so we can see exactly what it is you are doing (and not have to "guess" at some of these important details).

 

[sheetspread]

Re: Help! Today Function to Extract Data?

Is D127 the allotted time? If so you already have the answer (column D (apparently cumulative days???)/D127)

 

[ttop1010]

Re: Help! Today Function to Extract Data?

https://drive.google.com/open?id=1HsdJLCbSvNgewsf5YNcq97Ktu6431Uk4

let me know if this works, thanks again!