Search results for query: *

I had to go about it a different way but it worked. Thank you. I ended up having to say =G12-C8.

It is coming back with 10/24/2011

Ok I have the date and the week working together but them when I try to get the current day of the project and I type in =today()-C8 which is the cell that the project start date is in I get 1/29/1900 in the box where it should read 29

Thank you Unsolved

But see that is the part you are not explaining to me. I am trying to get help and you are telling me everything in terms I do not understand. I am not that versed in Excel. I know the basics but the basics are not going to get me what I need or want. I am asking for help and you are not...

Ok so explain what you are trying to tell me because it sounds like what you are doing is only going to control two of the cells that I am working with. I can already do that. I want to control all three. the cells that I am working with are B9 which is the day of cell, cell D12 which is the day...

Skip that I understand. I know when the project start date is and the duration of the project. But when I enter the information for one cell I want it to fill in the information for the remaining two cells. that is where i think you are not understanding me. I want to be able to write one...

@unsolved if you could please help me out with that I am not sure I understand what you are talking about. Are you suggesting that when I enter the date it will change everything if so that is great. But I am not sure I understand how you got from point a to point b by your explanation. If you...

Also if you look into my earlier posts I gave the cells that I am working with.

It should be 294. It was a typo. If you go from 9/26/2011-07/15/2011 it is 294 days. Since 2012 is a leap year. Like I said earlier I am wanting to be able to enter one number into the workbook and then it change the day of the week and the date. The only number I want to have to enter is the...

Just tried and it did not work. The cells that I am working with are cell A9 "Day of", Cell B9 is where the day number is entered and cell C9 says "of 291". When I enter an number in B9 I want it to change Cell D12 which is the day of the week (Monday thru Friday) and then also change cell G12...

I don't know if you opened up the excel workbook that I included but at the top it says Day: of Day further down in the workbook I have the weekday and then beside that I have the date. I know the VBA to deal with the date and day of the week but I am wanting one that when I enter a number in...

This explains why I need a VBA code that when I change the day of 291 I need it to change the day of the week and the date. The project is supposed to take 291 total days. The start date of the project was 09/26/2011 and the end date is 07/15/2012.

I don't know if I am going to explain this correctly but I am going to try. I am trying to help out my boyfriend by making it easier for him to complete his daily progress reports on the computer for his construction job. The VBA code that I need to create needs to control the date and the day...