Guys thanks for your help, things are working well now, I have formatted
date column as per your suggestions.
Hugs en Love
On Sat, Sep 18, 2010 at 3:10 PM, ALAM wrote:
> dear all
>
> plz find an enclosed files
>
> aftab ali
>
>
>
> On Sat, Sep 18, 2010 at 5:00 PM,
dear all
plz find an enclosed files
aftab ali
On Sat, Sep 18, 2010 at 5:00 PM, Vinod N wrote:
> Hi Janet,
>
> Please enter the date in Excel recognizable format i.e., mm/dd/ instead
> of dd/mm/. Then days can be calculated with the formula you have already
Hi Janet,
Please enter the date in Excel recognizable format i.e., mm/dd/ instead
of dd/mm/. Then days can be calculated with the formula you have already
entered.
Thanks
Vinod N
On Sat, Sep 18, 2010 at 1:48 PM, janet dickson wrote:
> Hi Team,
>
> I have challenge, see attached file. I
Hi Janet,
This can be possible if you have the dates in proper date format.
>From the data it seems that the dates are not in the proper format.
If you can enter the dates in a consistent format, then you can easily use
the following formula in Column C to get the days
=DATEDIF(A2,B2,"d") - Paste
Hi Team,
I have challenge, see attached file. I want to see days instead of dates
Hugs en Love
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exc