Get instant chat help with Excel and Google Sheets

Hi there! I'm trying to find the 'Age in Days' for each 'Enterprise Partner' on the 'Find Age' Days tab from the data in the 'Data' tab. I believe you can use a COUNT function, but I'm not sure I'm using it properly. Please provide an example of count function in excel for me to follow

I have two lists of data, lets call them the gold list and the blue list. Both lists have names and emails of people. The blue list is the most up to date, while the gold list has emails that are absent from the blue. I am trying to find a way to pull over the data from the gold list, in order to fill in empty spaces in the blue list, without overriding blue list entries

Vlookup not working for cells L2 and M2, I need to resolve the issue.

I need help on conditional formatting dates. So in short, I need the cells to be red if the date is between the 1st and 14th, then green if the date is between the 15th and 30th (or 31st). The current formula I am using is the following: RED =TODAY()>DATE(2017,8,1) =TODAY()>DATE(2017,9,1) =TODAY()>DATE(2017,10,1) =TODAY()>DATE(2017,11,1) =TODAY()>DATE(2017,12,1) GREEN =TODAY()>DATE(2017,8,15) =TODAY()>DATE(2017,9,15) =TODAY()>DATE(2017,10,15) =TODAY()>DATE(2017,11,15) =TODAY()>DATE(2017,12,15) So, I went in to the "Conditional Formatting" then went to manage rules, add rule. Then I did it in order of month, red to green. For example I would copy and paste the 8/17 red code and then the 08/17 green code, in order up to December 2017. It is now the 20th and I opened the excel sheet to check if the cell would be green because the date range but it is not. I have an attachable image.

I am missing something in the Vlookup function. I need to find all employee id in table 1 that also exist in table 2. Based on that it should read "exist" or "not exist"

I need help with a Countifs formula. I need help soon please

Hyperlinking a drop down list with a front sheet to another tab.

I need to roll forward a power pivot driven file into our next fiscal year, I can only get so far and can get the current year P&L to work correctly, but the balance sheet is not bringing up the true values, as its not returning the prior year accumulated balance... and it did before!

is there a way to combine a sumif and a countif function together: =SUMIF('Store Data'!BM:BN,"*"&B21&"*",'Store Data'!BL:BL(COUNTIF('Store Data'!BQ:BQ,"Yes"))) Currently the above formula returns the answer #REF

A formula that worked when one of your people helped me online is not working on my native file on desktop