| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calendar or date formulas
I have a date on one column, and would like the column next to it to
autmomatically calculate 6 months on, and auto fill with that date. I'm sure there is a formula for it, but I can't find one, or I'm entering the wrong question into the search. Can anyone help here? Many Thanks in Advance. Sarah M. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calendar or date formulas
Six months is 182 days, so you could do it like this:
=A1+182 or like this: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) assuming the date is in A1. Format the cell as a date, and then copy the formula down. Hope this helps. Pete On Jul 4, 9:56*am, Lady P wrote: I have a date on one column, and would like the column next to it to autmomatically calculate 6 months on, and auto fill with that date. I'm sure there is a formula for it, but I can't find one, or I'm entering the wrong question into the search. Can anyone help here? Many Thanks in Advance. Sarah M. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calendar or date formulas
On Jul 4, 1:56*pm, Lady P wrote:
I have a date on one column, and would like the column next to it to autmomatically calculate 6 months on, and auto fill with that date. I'm sure there is a formula for it, but I can't find one, or I'm entering the wrong question into the search. Can anyone help here? Many Thanks in Advance. Sarah M. Sarah, u can use EDATE(Initial Date,6) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Convert a Julian Date to Calendar Date | Excel Discussion (Misc queries) | |||
| How to link an Excel file due date to Outlook calendar date? | New Users to Excel | |||
| have a date cell pop up a monthly calendar to choose a date | Excel Worksheet Functions | |||
| Formulas needed for Calendar? | New Users to Excel | |||
| how to convert julian date to regular calendar date | Excel Worksheet Functions | |||
Linear Mode
