---
title: BizInsight Time Saver Tip 2 - Month-To-Date and Year-To-Date
description: BizInsight Time Saver Tip 2 - Month-To-Date and Year-To-Date
image: https://blog.oasisky.com/hubfs/Imported_Blog_Media/bizinsight-1-1.png
---

[![Oasis Solutions](https://blog.oasisky.com/hs-fs/hubfs/2-1.png?width=300&height=150&name=2-1.png "Oasis Solutions")](http://oasis.solutions)

Search for:

[Help Desk](https://oasisky.com/help-desk/)

Search for:

[Help Desk](https://oasisky.com/help-desk/)

# BizInsight Time Saver Tip 2 - Month-To-Date and Year-To-Date

by [Oasis Solutions](https://blog.oasisky.com/author/oasis-solutions)  | Jan 26, 2015 | [News](https://blog.oasisky.com/tag/news), [Industry Insights](https://blog.oasisky.com/tag/industry-insights)  | [0 Comments ](https://blog.oasisky.com/blog/bizinsight-time-saver-tip-2-month-to-date-and-year-to-date#comments-listing)

- [Tweet](https://twitter.com/share)

**How to:  – Quickly copy your Month-To-Date column to create a Year-To-Date column**

If you are designing a report that contains both Month-To-Date (MTD) and Year-To-Date (YTD) columns, you can quickly create the YTD column from your MTD column.

 

1.     Establish your MTD column with the desired BizInsight formulas and formatting.  It is important to properly anchor your cell references in your BizInsight formulas, as in this example:

![bizinsight-1](https://blog.oasisky.com/hs-fs/hubfs/Imported_Blog_Media/bizinsight-1-1.png?width=492&name=bizinsight-1-1.png)  
 2.     Once you have completed the column as desired, copy the column and paste into the column where you will have the YTD values.  (You may receive errors if you did not properly anchor your cells before copying.)

 3.     Highlighting ONLY that YTD column that you just pasted, you can do a Find/Replace in Excel.  Find all MTD and replace with YTD, then click Replace All.  (CAUTION: If you do not highlight only the YTD column you want to change, it will change all the values in your entire worksheet!)

 

![bizinsight-2](https://blog.oasisky.com/hubfs/Imported_Blog_Media/bizinsight-2-1.png)

 

What was once a MTDNET_S1GL function now becomes a YTDNET_S1GL function.

 

Still have questions? [**Contact Us**](http://www.oasisky.com/contact)

### Categories

- [ERP (282)](https://blog.oasisky.com/tag/erp)
- [News (192)](https://blog.oasisky.com/tag/news)
- [Industry Insights (76)](https://blog.oasisky.com/tag/industry-insights)
- [Press Release (52)](https://blog.oasisky.com/tag/press-releases)
- [Oasis Team (48)](https://blog.oasisky.com/tag/oasis-team)
- [Our Partners (27)](https://blog.oasisky.com/tag/our-partners)
- [Best Practices (22)](https://blog.oasisky.com/tag/best-practices)

[See all](https://blog.oasisky.com/blog/bizinsight-time-saver-tip-2-month-to-date-and-year-to-date#)

### Recent Posts

![Oasis Solutions](https://blog.oasisky.com/hubfs/Oasis_Solutions_January2019/Images/footer-rev-logo@2x.png)

#### [Connect With Us](https://oasisky.com/contact)

- Headquarters
- [Louisville, KY 40222](https://oasisky.com/louisville-kentucky-hq/)
- [Phone: 502.429.6902](tel:15024296902)

- [Lexington, KY 40504](https://oasisky.com/lexington-ky/)
- [Nashville, TN 37219](https://oasisky.com/nashville)

- [Facebook ](https://www.facebook.com/OasisSolutionsGroup)
- [Twitter ](https://twitter.com/Oasisky)
- [YouTube ](https://www.youtube.com/channel/UCPk1-r7nnH9H8_xUF0Cdb8Q)
- [LinkedIn ](https://www.linkedin.com/company/oasis-solutions-group)

#### ERP

#### Business Intelligence

#### CRM

#### Other Solutions

#### About Oasis

#### Learn

[![Oasis Solutions Group BBB Business Review](https://seal-louisville.bbb.org/seals/blue-seal-200-130-bbb-6000955.png)](http://www.bbb.org/louisville/business-reviews/computer-software-publishers-and-developers/oasis-solutions-group-in-louisville-ky-6000955/#bbbonlineclick)

© 2025 Oasis Solutions

[Help Desk](https://oasisky.com/help-desk/)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Oasis Solutions",
    "url" : "https://blog.oasisky.com/author/oasis-solutions"
  },
  "dateModified" : "2019-04-08T20:33:09.951Z",
  "datePublished" : "2015-01-26T17:07:53.000Z",
  "headline" : "BizInsight Time Saver Tip 2 - Month-To-Date and Year-To-Date",
  "image" : [ "https://blog.oasisky.com/hubfs/Imported_Blog_Media/bizinsight-1-1.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.oasisky.com/blog/bizinsight-time-saver-tip-2-month-to-date-and-year-to-date",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.oasisky.com/hubfs/Oasis-logo-vertical-multi-black-1.png"
    },
    "name" : "Oasis Solutions"
  }
}
```