Date formula

[chedges]

I am not sure whether this is possible, but I want to do a forumla that I can drag along the row, which will give me dates consequtively from say today, but that excludes weekends-so just business days.

so eg: 02Feb 05Feb 06Feb 07Feb 08Feb 09Feb

Thanks in advance

[Bryan Hessey]

I am not sure whether this is possible, but I want to do a forumla that I can drag along the row, which will give me dates consequtively from say today, but that excludes weekends-so just business days.

so eg: 02Feb 05Feb 06Feb 07Feb 08Feb 09Feb

Thanks in advance

try (in B1) date in A1, formula fill leftwards


=IF(WEEKDAY(OFFSET(B1,0,-1),2)=5,OFFSET(B1,0,-1)+3,OFFSET(B1,0,-1)+1)

hth
---

[daddylonglegs]

You can do this without a formula. If you drag the date in A1 across as far as you need then use Edit > Fill > Series and choose weekday option...

...or with a formula, using Analysis ToolPak function WORKDAY

=WORKDAY(A1,1)

or without Analysis ToolPak,

=A1+CHOOSE(WEEKDAY(A1),1,1,1,1,1,3,2)