Formulas - count the amount of working weeks from a date until present date

**Andrew_Franklin** · 01-09-2008, 05:44 AM

HELP PLEASE!!
I am an intermediate user of excel but I am struggling with a certain formula.

I am looking for a formula that will count the amount of working weeks from a date until present date!?? Can anyone help?

Regards

Andy

**broro183** · 01-09-2008, 06:14 AM

hi Andy,

Chip's below link is a page full of info with various links at the bottom for working with dates & somewhere in one of the links you should be able to find exactly what you want (perhaps the "datedif" or "weeks, difference between...").

http://www.cpearson.com/Excel/datetime.htm

hth
Rob

**daddylonglegs** · 01-09-2008, 08:52 AM

I think you'd have to define exactly what you mean by working week

You could use NETWORKDAYS function (which is part of Aanalysis ToolPak add-in) to count working days and then divide by 5

=NETWORKDAYS(A1,TODAY())/5

assuming your date is in A1. Note the count includes both A1 and today and you may not get a whole number.

You could count Mondays between your date and TODAY()...

=INT((WEEKDAY(A1-2)+TODAY()-A1)/7)

but if today is Monday and A1 was 7 days ago this will count both Mondays....

**Andrew_Franklin** · 01-09-2008, 09:23 AM

Hi Guys,

Thank you very much for your help! I will look at this today and I need anymore help I will shout. Much appreciated.

Kind Regards

Andy

Formulas - count the amount of working weeks from a date until present date

LinkBack

Thread Tools

Rate This Thread

Display

Formulas - count the amount of working weeks from a date until present date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions