How can I enter two dates and have Excel calculate the number of weeks or
days between them?
Thanks for any help.
Gene
How can I enter two dates and have Excel calculate the number of weeks or
days between them?
Thanks for any help.
Gene
Begin date in A1, end date in B1...........
this will give you days difference (format cell for general)
=B1-A1
and this will give you weeks..........
=(B1-A1)/7
Vaya con Dios,
Chuck, CABGx3
"Kobra" <[email protected]> wrote in message
news:[email protected]...
> How can I enter two dates and have Excel calculate the number of weeks or
> days between them?
>
> Thanks for any help.
>
> Gene
>
>
Chuck wrote <<Begin date in A1, end date in B1
............ this will give you days difference (format cell for general)
=B1-A1 and this will give you weeks
........... =(B1-A1)/7>>
Beware, you may be falling into common trap. This only returns the days
difference. In some instances you may need to also count day one. In which
case -
this will give you days difference (format cell for general)
=B1-A1+1
and this will give you weeks
=(B1-A1+1)/7
Regards.
Bill Ridgeway
Computer Solutions
"CLR" <[email protected]> wrote in message
news:%[email protected]...
> Begin date in A1, end date in B1...........
> this will give you days difference (format cell for general)
> =B1-A1
> and this will give you weeks..........
> =(B1-A1)/7
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Kobra" <[email protected]> wrote in message
> news:[email protected]...
>> How can I enter two dates and have Excel calculate the number of weeks or
>> days between them?
>>
>> Thanks for any help.
>>
>> Gene
>>
>>
>
>
Hi Kobra........
My original formulas gave you what I thought you wanted, (counting the end
date and not the start date).
Bill gave you another slant on it, (counting both start and end dates).
I guess actually, to give you exactly what you ask for, the formula should
be
=B1-A1-1 to give you the "days between" the two dates, (counting neither
start or end date)
=(B1-A1-1)/7 to give you the "weeks between" the two dates, (counting
neither start or end date)
All three sets of formulas work, it's just up to you to decide which way
serves your end purpose best.......
Vaya con Dios,
Chuck, CABGx3
"Kobra" <[email protected]> wrote in message
news:[email protected]...
> How can I enter two dates and have Excel calculate the number of weeks or
> days between them?
>
> Thanks for any help.
>
> Gene
>
>
Yes...that works...thank you very much.
Kobra
"Kobra" <[email protected]> wrote in message
news:[email protected]...
> How can I enter two dates and have Excel calculate the number of weeks or
> days between them?
>
> Thanks for any help.
>
> Gene
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks