ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formuals (https://www.excelbanter.com/excel-discussion-misc-queries/185695-formuals.html)

Gene McKinney YMCA international

Formuals
 
Code Number Status Last Name Arrival DateDeparture Date
ZAMY 1002 Placed Zulu 5/31/2008 XXXXXXX
ZAMY 1038 Placed Silwamba 5/15/2008 8/10/2008
ZAMY 1063 Placed Musopelo 6/6/2008 8/19/2008

Where the XXXXXX is located. I need to take the date in Arrival Date and add
84 days to the 5/31/2008 . PLEASE I am despert....

Gary''s Student

Formuals
 
With your 5/31/2008 in E1, enter in F1:

=E1+83

this will display 8/22/2008
--
Gary''s Student - gsnu200782


"Gene McKinney YMCA international" wrote:

Code Number Status Last Name Arrival DateDeparture Date
ZAMY 1002 Placed Zulu 5/31/2008 XXXXXXX
ZAMY 1038 Placed Silwamba 5/15/2008 8/10/2008
ZAMY 1063 Placed Musopelo 6/6/2008 8/19/2008

Where the XXXXXX is located. I need to take the date in Arrival Date and add
84 days to the 5/31/2008 . PLEASE I am despert....


Marcelo

Formuals
 
assuming 5/31/2008 is in e1

use =e1+84

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Gene McKinney YMCA international" escreveu:

Code Number Status Last Name Arrival DateDeparture Date
ZAMY 1002 Placed Zulu 5/31/2008 XXXXXXX
ZAMY 1038 Placed Silwamba 5/15/2008 8/10/2008
ZAMY 1063 Placed Musopelo 6/6/2008 8/19/2008

Where the XXXXXX is located. I need to take the date in Arrival Date and add
84 days to the 5/31/2008 . PLEASE I am despert....



All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com