Results 1 to 5 of 5

Weekday function into VBA

Threaded View

Libster78 Weekday function into VBA 03-09-2010, 06:29 AM
JeanRage Re: Weekday function into VBA 03-09-2010, 06:51 AM
Libster78 Re: Weekday function into VBA 03-09-2010, 07:05 AM
JeanRage Re: Weekday function into VBA 03-09-2010, 07:15 AM
Libster78 Re: Weekday function into VBA 03-09-2010, 07:20 AM
  1. #1
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Glasgow
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    105

    Smile Weekday function into VBA

    Hi there

    I need this function
    =A1+60+7-WEEKDAY(A1+60+1)
    into a macro

    Its the weekday section that I can'[t get.

    I've got
    Private Sub DetermineDeadline()
    With ws1.Cells("H6") + 60 + 7 - Weekday
    ws1.Cells ("H6") + 60 + 1
    End Sub
    Thank you
    Last edited by Libster78; 03-09-2010 at 07:20 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1