If you need to calculate a date in Excel that is a certain number of days in the future, you can simply enter a formula adding the correct number of days to a date.\u00a0 For example, if you wanted to calculate a due date for an invoice with terms of net 30, and the invoice date was in cell B2, you could use the formula =B2+30. That will give you a date 30 days from the date in cell B2.<\/p>\n
What if you want to get the same date one or more months in the future, such as a next billing date?\u00a0 In this case you can use a function named EDATE.\u00a0 The format is simple.\u00a0 It’s just EDATE(start_date,months).\u00a0 For example, if the last invoice date (1\/15\/2012) is in cell B2 and you need to find the next quarterly billing date, you could use the formula =EDATE(B2,3).\u00a0 That will give you 4\/15\/2012, the date 3 months from 1\/15\/2012.\u00a0 If the date in B2 was 1\/31\/2012, the formula’s result would be 4\/30\/2012, since there are only 30 days in April.<\/p>\n
With either approach you may get a number instead of something that looks like a date.\u00a0 This is because Excel tracks dates as a serial number with January 1st, 1900 as day 1.\u00a0 If that happens, right click on the cell, choose Format Cells<\/em>, and select a date format from the list.<\/p>\n To calculate a prior date, subtract the number of days, or use a negative number for the months if using EDATE.<\/p>\n","protected":false},"excerpt":{"rendered":" If you need to calculate a date in Excel based on another date, such as a due date that is 30 days after an invoice date, or scheduling a follow-up 3 months after a meeting, you can do so using a simple formula to add a number of days to a date, or using the EDATE function to get the same date in a future (or past) month.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/657"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=657"}],"version-history":[{"count":1,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/657\/revisions"}],"predecessor-version":[{"id":658,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/657\/revisions\/658"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}