Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count day's
when i enter a date in A1 and another date in B1, i want that in C1 should
calculate the days, EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week and 3 days, (not 10 days) -- mf |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count day's
=INT((B1-A1)/7)&" week "&MOD(B1-A1,7)&" days"
-- __________________________________ HTH Bob "moshe" wrote in message ... when i enter a date in A1 and another date in B1, i want that in C1 should calculate the days, EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week and 3 days, (not 10 days) -- mf |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count day's
moshe;223756 Wrote: when i enter a date in A1 and another date in B1, i want that in C1 should calculate the days, EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week and 3 days, (not 10 days) -- mf Try =int((finishdate-startdate)/7)&" weeks "&mod((finishdate-startdate),7)&" days" -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61931 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count day's
Try this
=INT(DATEDIF(A1,B1,"d")/7) &" Weeks " &MOD(DATEDIF(A1,B1,"d"),7) & " Days" Note that DATEDIF isn't documented in Excel so for help look here http://www.cpearson.com/excel/datedif.htm Mike "moshe" wrote: when i enter a date in A1 and another date in B1, i want that in C1 should calculate the days, EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week and 3 days, (not 10 days) -- mf |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count day's
And note also that if you are counting days, you don't need DATEDIF.
DATEDIF(A1,B1,"d") is the same as B1-A1 -- David Biddulph "Mike H" wrote in message ... Try this =INT(DATEDIF(A1,B1,"d")/7) &" Weeks " &MOD(DATEDIF(A1,B1,"d"),7) & " Days" Note that DATEDIF isn't documented in Excel so for help look here http://www.cpearson.com/excel/datedif.htm Mike "moshe" wrote: when i enter a date in A1 and another date in B1, i want that in C1 should calculate the days, EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week and 3 days, (not 10 days) -- mf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Networkdays to open previous day's file | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |