Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate weekdays only
On Tue, 21 Sep 2004 13:55:02 -0700, "benb"
wrote: I am looking for code to insert yesterday's date if yesterday was a weekday, and to use the previous Friday's date otherwise (if yesterday was Sunday). Anyone know how to do this? Thanks. Some more thoughts: If you don't have/don't want to have the ATP installed, I believe this formula will work: =A1-1-WEEKDAY(A1)*(WEEKDAY(A1)<3) If you want it as a UDF, you can implement the same function in code: ============= Function PrevWD(dt As Date) As Date PrevWD = dt - 1 + Weekday(dt) * (Weekday(dt) < 3) End Function ============= Note that in code you have to reverse the sign of the weekend adjustment due to the way that VBA handles booleans. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekdays | Excel Discussion (Misc queries) | |||
calculate weekdays only | Excel Programming | |||
calculate weekdays only | Excel Programming | |||
calculate weekdays only | Excel Programming | |||
Calculate weekdays from two dates | Excel Programming |