excel date formula

Can we build a single formula to auto-populate the list of dates as shown in column 'G', based on the payment cycles set in (i) & (ii) and the list of dates provided in (iii), without repeating common dates between them? For now, I prepared separate list of dates using formulas to calculate...

I am trying to return the last input in a date range, for example January the input was on the 31st for an amount of 5, February the last input was on the 26th in the amount of 10 and march the last input was on the 17th in the amount of 23, and this will go on for the rest of the year on random...

Hi Everyone, I have a task where, a start date is set (it will come the variable). Once the start date change, another cell will update based on the cell. If the start date change to another date, due date also need to add based on how many days it change. The start date is a variable so it...

Hi, I am struggling a bit to get my date formulas working. In a sense it is a 2 pt question. I basically have a date of which I need to add X amount of days which may go into into the next month at times. Then if that target date after getting added x days is a weekend or holiday it needs to go...

Good morning, I need to set up a formula. I have a spreadsheet that calculates future dates for review. What I need my formula to do is to calculate a future date only if the cell is greater than a specific number IF not then blank. in the example below I only want future dates to populate if...

Hi all, For the record, I know, the obvious answer is "every year.":laugh: but seriously, I have a question. I am trying to write a formula the give me a date that a given report will be due. The reports each have a set annual due date based on the employee's position. An example would be...

Hi Everyone, I am looking for a formula which would return the value as 5th day of next month based on any random date of current month (from 1 to 31 ). For Example, My Cell "A1"contains 15-May-2016, i need a formula in "B1" which will return the value as 05-June-2016. Similarly, if i change...

I'm helping a friend with a spread sheet for her caravan park, She wants to input the number of weeks someone wants to stay as an integer say 2 for 2 weeks after having already input a start date for their stay and have excel calculate and display an end date. Start Date NUMBER OF WEEKS...

I need a formula to find the 15th of the NEXT month BUT if the 15th falls on a weekend, I need it to default to Monday. Any suggestions? ;)

I need to add a set time to the end of my date (that changes) in a cell. Meaning I am displaying the first day of the month but need the time to always be 7:00AM. Here is what I am using for the date =EOMONTH(TODAY(),-1)+1 Thanks in advance!

Hi, Is there a formula that will pull the DD or MM from a date format of DD/MM/YYY only? I have two excel sheets and i want to link the date from sheet 1 to sheet 2. On sheet 1 the date is in this format DD/MM/YYYY and this is in 1 full cell as we add the date quickly using Ctrl+: Sheet 2...