Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 13th 11, 09:16 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 18
Default Networkdays Today + 1

I need a formula for today's date + 1 day (next business date). But
if today is friday then I need the mondays date.

  #2   Report Post  
Old September 13th 11, 09:22 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,731
Default Networkdays Today + 1

Am Tue, 13 Sep 2011 13:16:17 -0700 (PDT) schrieb BetaDocuments:

I need a formula for today's date + 1 day (next business date). But
if today is friday then I need the mondays date.


Your date in A1, then
=WORKDAY(A1,1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Old September 13th 11, 09:22 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default Networkdays Today + 1

On Tue, 13 Sep 2011 13:16:17 -0700 (PDT), BetaDocuments wrote:

I need a formula for today's date + 1 day (next business date). But
if today is friday then I need the mondays date.


=workday(today(),1)

If this function gives you a #NAME error, and you are using a version of Excel prior to 2007, see HELP for the workday function for the fix.
  #4   Report Post  
Old September 13th 11, 09:35 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 18
Default Networkdays Today + 1

On Sep 13, 4:22*pm, Ron Rosenfeld wrote:
On Tue, 13 Sep 2011 13:16:17 -0700 (PDT), BetaDocuments wrote:
I need a formula for today's date + 1 day (next business date). *But
if today is friday then I need the mondays date.


=workday(today(),1)

If this function gives you a #NAME error, and you are using a version of Excel prior to 2007, see HELP for the workday function for the fix.


Excellent!! It worked exactly the way I wanted


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF TODAY equals date in cell A10, or if TODAY is beyond that date SoupNazi Excel Worksheet Functions 4 April 23rd 07 01:14 AM
networkdays rsenn Excel Worksheet Functions 0 November 24th 05 01:42 AM
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo. Fkor Excel Discussion (Misc queries) 3 March 10th 05 09:29 AM
networkdays Liesel1 Excel Worksheet Functions 3 January 17th 05 07:49 PM
Networkdays Dmorri254 Excel Worksheet Functions 9 January 14th 05 04:55 AM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017