dates

Hi First time posting so please be gentle :) I have a set two sets of dates one in column E (Target Date) and one in O (Actual Finish Date) The sheet I have inherited uses the below formula: =IF(O2="",IF(E2>NOW(),"OPEN","OVERDUE"),IF(O2>E2,"FAIL","PASS")) What I need the new formula to do...

Hi - I am checking if any projects at work fall between a change freeze - either their start or end date. There are a few scenarios - projects starting within the period and then going several months ahead, projects starting before and finishing during the project - but essentially each...

I feel embarrassed to ask this question but I have searched for a solution and can’t find the solution. I have several dates in Column H. I want to format cells that have dates than are 365 days or older Red. I want similar formats for cells that are between 365 days and 180 days Orange I want...

Hi, Consider this table of employees off sick. Person A has had several periods of time off, and they happen to be all consecutive, totalling 158 days. I am struggling for a formula/Method to return the number of consecutive days Person A has had off?? Person Off Date Back Date Days Off...

Hello I am hoping someone may be able to help me. I have a list of birthdates and in my job, I have to purchase gifts for everyone's birthday. Ideally, I like to do this 3 weeks before the birthday comes up to give me time to buy the gift and get it sent to them in good time. It would help me...

Hi everyone. I am hoping someone can explain a solution for me in layman's terms please! I am not great with complex formulas. In my original sheet I have the following data as an example: This can be interpreted as Test Employee needs to attend 123 Example Street every Tuesday and Thursday...

Hello All! I'm trying to create a formula that counts the number of unique dates with two criteria. I've actually searched within this forum and found a similar question, however because it was case-specific and the conditions differ to mine, the same cannot be applied to mine. The one with 2...

Hello, Here I am again...stuck at the dates. Ok, our company first week of this year starts from Monday 12/30/2019; other words, our first quarter starts from 12/30/2019. However, on my pivot table when I group the dates, Excel group 12/30/2019 as 4th quarter. ? Is there anything I can do to...

Hi, I have a column (D) in my workbook that shows when a file was last updated. I need help with a formula (or whatever approach is right) to determine how long it has been since it's last update. I would like to use the current date comparing against what the date is in the column it was last...

I am a Field Sales rep and I have an excel report of what hospitals I went to on what days. I'm trying to make a heat map using conditional formatting to visualize time passage regarding who I haven't visited recently. I'm using the below formula to pull up the visit date minus today's date...

Hi there, I have a file with historic data which is weekly updated with a Month to date raw data can anybody help me to delete rows only from the current month? Date is on column B And on column AC I have a =MONTH(B3) formula.

I think this code is incorrect, it seems to be pasting the the dates the wrong way around and i know that its something simple but i cant figure it out. Workbooks.Open "P:\FETS Command\Business Services\STORES OFFICE\James - Work\#LineItemsReport\PurchaseOrders.csv"...

Hi All, I have a data of 3 years daily exchange rate history. However, some dates (weekends, holidays) with corresponding rates are missing. I would like to fill in missing dates and copy the previous day's rates (for which data is missing) to missing date. So, in the example, the dates...

Hi Experts, I am looking for a macro code to create rows per employee based on the start & end date. Each employee will have LOP dates with From & To date, I need to create each row per employee for the dates available between dates. Attached screenshot for reference. Regards, Harish S

does any one know a location for the excel function by @Jon von der Heyden which displays AutoFilter criteria (including the date filter) in an Excel sheet

Hi, I've got a spreadsheet with 21 active worksheets. 1 of those is a home page and the other 20 all have data on regarding deliveries for my company. I want to make it so that Excel automatically searches for any deliveries >=TODAY on all the worksheets and copies those rows onto a new sheet...

Hi all, I'm trying to create a column in power query editor that looks at a date and inserts 'exclude' if it's after 1Apr2020 and inserts 'include' otherwise. The editor, however, says using <= or >= doesn't work for dates. What expression should I use instead? Todd

Hi, I need help in calculating start and finish date in a gantt chart color range. I have a excel with some data and gantt chart with color range between dates. I wanted a macro which show me the start and finish between a gantt chart color range. Attaching screenshot. Thanks

Hi all. i searched the board and i found how to convert dates (which didn't work for me) and there is lots of info on how to convert dates, BUT the data that im receiving is DUMB because im getting MIXED data and excel can read SOME of it but not all of it... and its SUPER anoying... is there a...

Trying to figure out a Countifs formula to provide Something that is greater than 30 days but less than 90. Using a cell reference for the date. Example: A1 = 1/6/2020, trying to figure out if its greater than 30 days I've tried but can't figure it out...