| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help w/formula to add 1 year to cell (date done) date due?
Can someone help me with a formula that would allow me to put today's date in
one cell (date done) and then add one year so that the next cell would come up with the date one or two years from now (date due)? Thanks GregJ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help w/formula to add 1 year to cell (date done) date due?
Hi,
=DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODAY())) should do the job ... HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help w/formula to add 1 year to cell (date done) date due?
if your initial date is in A1, try
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) and format for the date style you want "GregJ" wrote: Can someone help me with a formula that would allow me to put today's date in one cell (date done) and then add one year so that the next cell would come up with the date one or two years from now (date due)? Thanks GregJ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help w/formula to add 1 year to cell (date done) date due?
Hi,
Try this: (Assuming today's date in Cell A1. B1 is for putting one year or two years. Put this formula in C1) =IF(B1=1,(A1+365),IF(B1=2,(A1+730+1))) Regards, Jaleel "GregJ" wrote: Can someone help me with a formula that would allow me to put today's date in one cell (date done) and then add one year so that the next cell would come up with the date one or two years from now (date due)? Thanks GregJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| extract name when a date in another cell gets near | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
