date formula

i have one simple question. i have date in one cell, lets say "A1" i am making every month attendance and i have calender A2=01,B2=02,C2=03,D2=04,E2=05,......AE2=31 what i did here A2=A1 to return first date of month and all A2+1,B2+1,C2+1.............. for until end date. its working fine if...

Hi, I have two dates in excel in A1 i have 201101 which is year and month together & in b1 i have 201202 which is year and month together i need to find out months in between the two dates... 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...

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

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

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?

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

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

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