PC Review


Reply
Thread Tools Rate Thread

Date calculations

 
 
kharal
Guest
Posts: n/a
 
      9th Apr 2010
I have a pre-given date and want to know the resulting date after adding a
certain number of days in pre-given date. Mathematically it is like:

pre-given date + days = resulting date

Pregiven date is in one cell of a table on presentation and days and
resultings date are in their own cells each.

Thanx in anticipation
 
Reply With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      9th Apr 2010
EXCEL 2007

Cell A1:-

01/04/2010

Cell B1:-

10

Cell C1:-

=(A1+B1)

This gives the answer 11/04/2010 in cell C1.

If my comments have helped please hit Yes.

Thanks.







"kharal" wrote:

> I have a pre-given date and want to know the resulting date after adding a
> certain number of days in pre-given date. Mathematically it is like:
>
> pre-given date + days = resulting date
>
> Pregiven date is in one cell of a table on presentation and days and
> resultings date are in their own cells each.
>
> Thanx in anticipation

 
Reply With Quote
 
David Marcovitz
Guest
Posts: n/a
 
      9th Apr 2010
That would be really helpful if this were an Excel question, but this is
a question about PowerPoint. I don't believe you can do calculations in
PowerPoint tables. You could do it in Excel, copy, paste special, paste
as link, but that might not give you quite the look you want.
--David

On 4/9/10 2:31 AM, trip_to_tokyo wrote:
> EXCEL 2007
>
> Cell A1:-
>
> 01/04/2010
>
> Cell B1:-
>
> 10
>
> Cell C1:-
>
> =(A1+B1)
>
> This gives the answer 11/04/2010 in cell C1.
>
> If my comments have helped please hit Yes.
>
> Thanks.
>
>
>
>
>
>
>
> "kharal" wrote:
>
>> I have a pre-given date and want to know the resulting date after adding a
>> certain number of days in pre-given date. Mathematically it is like:
>>
>> pre-given date + days = resulting date
>>
>> Pregiven date is in one cell of a table on presentation and days and
>> resultings date are in their own cells each.
>>
>> Thanx in anticipation



--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF AND calculations with date Ranking by type, and the dashes Microsoft Excel Worksheet Functions 5 24th Oct 2008 02:11 PM
Date Calculations before date entered =?Utf-8?B?TWEyV2Vpcg==?= Microsoft Excel Misc 8 1st Feb 2007 03:34 AM
Date calculations Graham Naylor Microsoft Access Form Coding 8 12th Nov 2003 02:52 PM
Date calculations Michael Neal Microsoft Access Database Table Design 1 8th Oct 2003 01:07 PM
Date calculations Mothra Microsoft Excel Worksheet Functions 2 19th Aug 2003 09:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:12 AM.