| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a formula for calculating dates 3 mos out
Here's an example
What is the formula I would use for calculating dates 3 mos. out ex. April 17, 2006 July 17, 2006 October, 17, 2006 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is there a formula for calculating dates 3 mos out
Let's say your original date is in cell A1. Use this formula:
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) Or if you want to calculate based on the current date: =DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY())) HTH, Elkar "Lawrence" wrote: Here's an example What is the formula I would use for calculating dates 3 mos. out ex. April 17, 2006 July 17, 2006 October, 17, 2006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date formula for extracting unique dates | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula including dates | Excel Worksheet Functions | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
Linear Mode
