Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation
I wanted to say thanks! I was trying to figure out something similar,
although not quite but your formula below was able to get my juices flowing and ultimately enabled me to find the result with the calculation I was seeking! Thanks so much for posting an answer to Suzanne's question! You made my life and the life of my staff so much easier! Michelle "Dave R." wrote: Hi, you can do this with =EDATE(A1,6) where A1 contains the date you are adding to. Be sure and format it as a date. or =EDATE("9/29/04",6) The result is actually 3/29/2005, not 5/29/2005 :) "Suzerain" wrote in message ... Hi. Does anyone know if there is a formula that I can use in Excel (XP 2003) to calculate an end date if you are given the start (9/29/2004) and then the number of Months (6), that the formula cell would show (5/29/2005)? Thanks in advance, Suzanne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return a value between date ranges | Excel Worksheet Functions | |||
Date Calculation to exclude weekends | Excel Worksheet Functions | |||
Calculation based with Range of Date | New Users to Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Due Date Calculation? | New Users to Excel |