Results 1 to 6 of 6

Skip a day of the week

Threaded View

Darbar Skip a day of the week 05-24-2005, 03:57 AM
Flintstone Hi Darbar: This is the... 05-25-2005, 04:21 PM
mangesh_yadav Use the following function.... 05-27-2005, 08:02 AM
Darbar Thank you 05-30-2005, 04:33 AM
mangesh_yadav Appreciate the feedback.... 05-30-2005, 05:30 AM
mangesh_yadav Found another solution... 06-06-2005, 09:31 AM
  1. 05-24-2005, 03:57 AM #1
    Darbar is offline
    Registered User
    Join Date
    05-24-2005
    Posts
    2

    Question Skip a day of the week

    Hi All,

    I have a situation like I need to skip Thursday(weekly off) from weekdays(sat & sunday are included). For example :


    Today is 24 May 2005 and if I add 4 to this date, it will give 28 May 2005. But in this I have one Thursday, it should ignore Thursday and I need a result like 29 May.

    Clear explanation of my query


    Say if cell A1 is having todays date and A2 is having number 4 then I need the specified result in cell C1. And the result should not include Thursdays.

    Can anyone please help me regarding this issue.

    Thanks in Advance

    Darbar
    Last edited by Darbar; 05-24-2005 at 06:01 AM. Reason: To give clear explanation
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1