PC Review


Reply
Thread Tools Rate Thread

Counting 45 days from a certain date

 
 
Sanjeev Raghavan
Guest
Posts: n/a
 
      4th Apr 2008
For eg. In have 22-Jan-08 in R4. I want to count 45 days from that day in S4
in date format.

I am not an expert in excel. That's why I need help.
Please help.
Regards,
Sanjeev.

 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      4th Apr 2008
In S4 enter:
=R4+45
and format S4 as date
--
Gary''s Student - gsnu200777


"Sanjeev Raghavan" wrote:

> For eg. In have 22-Jan-08 in R4. I want to count 45 days from that day in S4
> in date format.
>
> I am not an expert in excel. That's why I need help.
> Please help.
> Regards,
> Sanjeev.
>

 
Reply With Quote
 
Sanjeev Raghavan
Guest
Posts: n/a
 
      5th Apr 2008
That was very simple. Thank you Gary.

"Gary''s Student" wrote:

> In S4 enter:
> =R4+45
> and format S4 as date
> --
> Gary''s Student - gsnu200777
>
>
> "Sanjeev Raghavan" wrote:
>
> > For eg. In have 22-Jan-08 in R4. I want to count 45 days from that day in S4
> > in date format.
> >
> > I am not an expert in excel. That's why I need help.
> > Please help.
> > Regards,
> > Sanjeev.
> >

 
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
Counting days from a date Sunshine Microsoft Excel Worksheet Functions 3 17th Feb 2010 04:35 PM
counting number of days between today's date and start date =?Utf-8?B?QVNTSw==?= Microsoft Access Forms 6 25th Jul 2007 03:04 PM
Counting the days from a certain date in Outlook? =?Utf-8?B?Q2FybGE=?= Microsoft Outlook Discussion 2 15th Nov 2005 07:39 PM
Counting the number of days between two date Maddoktor Microsoft Excel Discussion 1 3rd Jun 2005 02:47 PM
Date Difference counting only working days Peter Microsoft Excel Misc 2 25th Oct 2004 12:09 PM


Features
 

Advertising
 

Newsgroups
 


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