Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET #OF WEE
I WANT A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET NUMBER OF
WEEKS 9DURATION) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET #OFWEE
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET #OF WEE
Please avoid all caps, it's harder to read and considered rude
to get number of weeks =(END-START)/7 without decimals =INT((END-START)/7) one might also round to the nearest integer =ROUND(((END-START)/7),0) -- Regards, Peo Sjoblom -- Regards, Peo Sjoblom "MARIEM" wrote in message ... I WANT A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET NUMBER OF WEEKS 9DURATION) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET #OF WEE
Dan,
Please correct me if I'm wrong, but doesn't DATEDIF work in days, months, and years? As far as I am aware, DATEDIF doesn't work in weeks? Surely for weeks it is merely a question of =(B2-A2)/7 ? -- David Biddulph "dan dungan" wrote in message ... See Chip Pearson's datedif page: http://www.cpearson.com/excel/datedif.aspx |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET #OFWEE
Hi David,
Woops. You're right. Thanks, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
how do you calculate monthly revenue in Excel 2007 | Excel Discussion (Misc queries) | |||
Calculate in bottom left hand corner in Excel 2007 | Excel Discussion (Misc queries) |