Creating a year to date transformation

**JPSIMMON** · 06-04-2014, 02:31 PM

I am looking to create a year-to-date transformation for data. I have two columns with a date in A and a data point (sales) in column B. I am looking to create a Year-to-date value by month, so Jan=Jan, Feb=Jan + Feb, Mar=Jan+Feb+Mar etc...

**Richard Buttrey** · 06-04-2014, 02:41 PM

Hi,

We really need to see the actual workbook in order to offer a definitive answer. But for example assuming your January sales are in B2 then in C2 copied down

Formula:

Please Login or Register  to view this content.

Creating a year to date transformation

LinkBack

Thread Tools

Rate This Thread

Display

Creating a year to date transformation

Re: Creating a year to date transformation

Thread Information

Users Browsing this Thread

Similar Threads

Keep month and date but change year to current year and reoccur when new year rolls over.

Creating Year to Date formula using Vlookup or sumif and exclude #N/A

[SOLVED] Keeping a date as current year, even though formula determines previous year

[SOLVED] Count days for specific year falling within in multi-year date range

Formula to calculate the percentage of a year using a start date and year to date dates

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions