| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate weekdays only
You can do this with formula or code. Which one is
necessary for your application? -----Original Message----- 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. . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate weekdays only
I prefer to do it with code. Is there also an Excel function that does this
I am unaware of? "Mike" wrote: You can do this with formula or code. Which one is necessary for your application? -----Original Message----- 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. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate weekdays only
dtDate = Range(A1)-1-choose(Weekday(Range(A1).Value)-1,2,0,0,0,0,0,1)
-- Regards, Tom Ogilvy "benb" wrote in message ... I prefer to do it with code. Is there also an Excel function that does this I am unaware of? "Mike" wrote: You can do this with formula or code. Which one is necessary for your application? -----Original Message----- 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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekdays | Excel Discussion (Misc queries) | |||
| Weekdays only! | Excel Discussion (Misc queries) | |||
| Weekdays | Excel Discussion (Misc queries) | |||
| calculate weekdays only | Excel Programming | |||
| Calculate weekdays from two dates | Excel Programming | |||
Linear Mode
