Hi
I'm looking to have a list of working days only e.g:
Thursday 12th April
Friday 13th April
Monday 16th April
I would like to do this so it's done automatically, i.e.
Thursday 12th April
=A1+1
=A2+1
Is there a formula to do this?
Thanks!!
Hi
I'm looking to have a list of working days only e.g:
Thursday 12th April
Friday 13th April
Monday 16th April
I would like to do this so it's done automatically, i.e.
Thursday 12th April
=A1+1
=A2+1
Is there a formula to do this?
Thanks!!
Crispie, try this :
Enter a date in A1
Type (or copy) the next formula in A2 :
Now you can copy this formula down. Don't forget to set the right format.Please Login or Register to view this content.
If you don't mind using Analysis ToolPak add-in you can also use WORKDAY function, i.e.
=WORKDAY(A1,1)
you can also add a holiday range as the third argument of WORKDAY to exclude holidays also......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks