Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
every quarter
Hi
Try application.WorksheetFunction.WorkDay(range("A1"), 90) -- Regards Roger Govier "A.G.M ash" wrote in message ... Actually just realised my error the answer is simple. but now i have come across another prob. how do i say if 90 days after 18th october = saturday or sunday then do nothing till monday "A.G.M ash" wrote: Hi Funny question for you all, been tryin to think of an answer but had no look. how do you tell excel to Do x every quarter but the quarter start and date to do is user defined i.e. Do x if date now() = 18th and month = three months after october date and month will be looked up in different cells but i can sort that out I just cant think of a way of telling excel to count 3 months from x month many many many thanx in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Day of Next Quarter | Excel Discussion (Misc queries) | |||
quarter | Excel Worksheet Functions | |||
every quarter | Excel Programming | |||
Quarter End Date | Excel Worksheet Functions | |||
First and Last Day of the Quarter | Excel Worksheet Functions |