Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate date so many days before/after current date.
I would like to take a date in A1 and in A2 have a set number of days from
that date. In A3 will be shown the date which is A2 days before/ahead of A1. Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as 27-Jan-12. Obviously this is an oversimplified result, my idea is to calculate many thousands of days ahead and before set specified dates. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate date so many days before/after current date.
On Jan 22, 6:34*pm, "Jake" wrote:
I would like to take a date in A1 and in A2 have a set number of days from that date. In A3 will be shown the date which is A2 days before/ahead of A1. Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as 27-Jan-12. Obviously this is an oversimplified result, my idea is to calculate many thousands of days ahead and before set specified dates. EXCEL 2007 In A1 put the date. In A2 put the number. In A3 put:- =A1+A2 - and it will display:- 27 January 2012 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate date so many days before/after current date.
"trip_to_tokyo" wrote in message ... On Jan 22, 6:34 pm, "Jake" wrote: I would like to take a date in A1 and in A2 have a set number of days from that date. In A3 will be shown the date which is A2 days before/ahead of A1. Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as 27-Jan-12. Obviously this is an oversimplified result, my idea is to calculate many thousands of days ahead and before set specified dates. EXCEL 2007 In A1 put the date. In A2 put the number. In A3 put:- =A1+A2 - and it will display:- 27 January 2012 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate date so many days before/after current date.
"trip_to_tokyo" wrote in message ... On Jan 22, 6:34 pm, "Jake" wrote: I would like to take a date in A1 and in A2 have a set number of days from that date. In A3 will be shown the date which is A2 days before/ahead of A1. Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as 27-Jan-12. Obviously this is an oversimplified result, my idea is to calculate many thousands of days ahead and before set specified dates. EXCEL 2007 In A1 put the date. In A2 put the number. In A3 put:- =A1+A2 - and it will display:- 27 January 2012 **** Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate date so many days before/after current date.
Jake,
To accomplish showing a range of dates in Cell A3, try the following: Cell Enter Cell Value/Formula A1 Date in the middle of Range you want. A2 days before/after A3 =TEXT(A1-A2,"dd-mmm-yy")&" to "&TEXT(A1+A2,"dd-mmm-yy") Cell Enter Cell Value/Formula A1 22-Jan-12 A2 5 A3 =TEXT(A1-A2,"dd-mmm-yy")&" to "&TEXT(A1+A2,"dd-mmm-yy") Result for A3 is: 17-Jan-12 to 27-Jan-12 -- Rich/rerat (RRR News) (message rule) ((Previous Text Snipped to Save Bandwidth When Appropriate)) "Jake" wrote in message ... I would like to take a date in A1 and in A2 have a set number of days from that date. In A3 will be shown the date which is A2 days before/ahead of A1. Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as 27-Jan-12. Obviously this is an oversimplified result, my idea is to calculate many thousands of days ahead and before set specified dates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |