date formula

  1. M

    TAX Calculator Date Query...Please Help

    Hi, I am trying to build a tax calculator/forecasting tool. I need it to be relevant and up to date. In summary Cell A1 is a date entry box. This is always my starting point. There are a number of transactions that are linked to a quarterly and bi annual cycle and I cannot come up with a...
  2. K

    Date output from changing cell range

    Hey guys, Just trying to work the logic to output dates for a sheet i am using for stock arrivals. As its setup, i have a list of customers with various amounts of the same product, with an ETA for arrival down 1 column. At the bottom of my sheet, i have purchase orders for various...
  3. J

    Months to years conversion help please

    Good morning everyone, I have been trying to figure out a formula to convert the amount of months in a certain cell to years. I have come up with: =INT(E29/12)&" years "&MOD(E29,12) & " months" The problem is it comes up with 2 years 3.37063951499227 months Does anyone know how I...
  4. J

    Help with date forumla please?

    Hi - I am looking to find a formula which gives me the date on Friday only. So, througout the week, the date listed stays the same until Friday when it changes to the current Friday's date. I hope this makes sense?
  5. J

    Help with dates please

    Hi, I was just wondering whether there was a formula to change a date once per week. For example, instead of using =today() is there a way that I can make the date stay on a Friday until the following one. So tomorrow it would change to 16/12/11 and stay like that until next Friday when it...
  6. P

    Average price depending on the day of the week

    Hi All, Long time reader but first time poster... I have been searching everywhere for a simple solution to get the average fuel cost depending on which day of the week it is. In other word, how much does fuel cost on Mondays, Tuesdays, etc. This is my unsuccessful attempt...
  7. Y

    Hide cells with date formula

    I have Excel 2004. Can anyone tell me how to hide the formula in a cell where I've set it up to calculate the date something is due, based on a cell where someone will enter a start date? The start date is blank until someone puts a date in there, and as a consequence my due date is coming up a...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top