dates

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...

I have been trying to figure out a formula to show how many days a project would take if a start date was given and hours of project assuming a person worked 8 hrs per day. See example below. I used the formula MIN(D$3-SUM($F$3:G3),8), which will "spread" the "8" until it reaches "0", but when...

Hi Guys, I have a couple of sheets that are accessed my one other person. I have dashboards with pivot tables that are all based around grouped dates. My colleague is in the habit of not filling the info out correctly and has been know to leave a date blank and refresh the workbook, hence...

Hello, This is my first post and I'm hoping to get a bit of help with creating a formula that I can use on a finance table that I've created. I am attempting to forecast my personal finances and want to insert fortnightly payments into a column automatically. I've managed to do this for my...

I regularly download a .csv file which I open in Excel and then save as 97-2004 workbook (.xls). Contained in this .csv file is a column with dates which are formatted as short dates. I can't seem to find a way to convert these to long dates other than changing the format and then manually...