dates formula

Hi all, I have been hunting for an answer to this for days and just getting nowhere :eeek: We have a table of rental service charges that have 4 key Fields; Start Date End Date Quantity Sell Price I have created a Date (calendar) Table and created a relationship to both the Start Date &...

My "Days Worked" column keeps breaking with every new month... and i think i have it coded wrong. My formula is =NETWORKDAYS($C$7,$C$8)*-1-$C$11 C7 is Today / C8 is Start Date (beginning of the month) / C11 is Holidays (which i manually enter due to company picks).. Currently it's showing...

I have a range of dates in column A and I only need to identify the dates within the last 2 years. Is there a way to use conditional formatting to only highlight the dates that are within the last 2 years? Thanks in advance!

Good day all, The time sheet currently used was created in MS Word and updating it every month requires updating quite a few cells (Individual Days, End of Week, Current Month, etc.) so to save time I translated the time sheet into Excel keeping an almost identical layout. The existing MS Word...

Thanks for taking the time to read and think. I'm building a financial model and have a simple date row at the top of every tab. The formatting is Date, US, Mar-12 (example). I have a few tabs that deal with Headcount and Roll Out and in these tabs I'm using a conditional formula to return a...

I'm preparing a data source in Power query and I'm having some trouble with formulas involving date columns which legitimately have a lot of null values. Is there an equivalent to NVL (oracle) in Power query I can use when writing the formulas to deal with null values as I'm getting errors...

I am working with a range of dates that tasks were completed. However some of the cells are blank because the tasks are in process. I need a formula to return the most recent date indicated in the rage once all of the cells in the range have completed dates by them. GG

Hello Am new to excel formulas, and while I have tried to solve this problem, I really need some help :biggrin: I have a job sheet, with a job start date and a job due date. I manually create a timeline with 2 colors of cell to visually show when a job starts and when it is due. Here's a...

I know this will be too easy too answer for you gurus. The table I manage contains assignments for various people, and a due date for each assignment (different assignment per row). My boss wants a separate list of all assignments that are overdue (every week he wants an updated list). I'd...

Hi, I am requesting someone to help me with the following problem: I have a number of dates entered in Column A out of which most of them are repeated and data in the rest of the column. I have to find the first date and the last date and have it automatically entered in sheet 2 cell c3 "Start...

Good afternoon. I am looking for a formula which gives the amount of working hours between 2 dates. Working hours are monday - Friday and 10am - 6pm Any help would be very much appreciated. Thanks