Excel Formula

[Dubbercody]

I am trying to figure out how to create a year to date and month to date formula within excel. Sounds easy but I have two worksheets one for Data Processing and one for a final report.

I change the data on the first worksheet daily and I need to figure out how to get the info to save for each cumulative day. Essentially it's a summation that needs to save prior data...HELP...

I'm sure this is possible, but I haven't been able to figure out the formula as of yet. If anyone has any ideas I'd be quite thankful.

[VHockey86]

I'm not sure about everyone else. but im not sure exactly what you want the formula to do yet. When you say "a year to date and month to date" what does this mean? Could you give an example with some numbers?

[Epidemic]

well I am not sure what you are trying to do but I will take a crack at it anyway.

You could write a small macro to put the date in front of each record from the date in question. Using he Now() function then copy -paste special- values to eliminate the formula when done.

You could also use the now function to create the date and make


You would have to automate the range where date is to be located but you could use this.

Sub dat()
datevar = Month(Now()) & "/" & Day(Now()) & "/" & Year(Now())
Range(Cells(1, 1), Cells(10, 1)) = datevar
End Sub

[Epidemic]

Dubbercody,

Dang I have to check the post count before putting too much effort into these questions.

Duke, that looks like a good way to do it.

You is better slow down. Toching 500.

[Epidemic]

498

[jerrygarcia]

Double, oops.

[jerrygarcia]

1618





Total spam, sorry.

Duke's starting to look bad with so many posts.

BTW, so as not to spam, what exactly does that formula do, Duke? Like calculate some stuff or conditional stuff or what?

[Dubbercody]

I'm trying to put in data for one day...and have the data saved to a Year to date formula. The data will be updated each day, so i need to figure out a way to get the daily data to save and add into the YTD cell.