Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for if result is friday, make it thursday.
I have the following formula:
=WORKDAY(DATE(YEAR(G1),MONTH(A46)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(G1),MONTH(A46)+1,0),2)-5)),-7) basically it gives me the 8th last working day of the month. Now if the result of that is a Friday, I want it to diplay Thursday's date. or if the result is Monday, I want it to display Tuesday's date. Does this make sense? any help greatly appreciated. thanks joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for if result is friday, make it thursday.
On Wed, 6 Feb 2008 10:28:05 -0800, joe schmo
wrote: I have the following formula: =WORKDAY(DATE(YEAR(G1),MONTH(A46)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(G1),MONTH(A46)+1,0),2)-5)),-7) basically it gives me the 8th last working day of the month. Now if the result of that is a Friday, I want it to diplay Thursday's date. or if the result is Monday, I want it to display Tuesday's date. Does this make sense? any help greatly appreciated. thanks joe How about: =WORKDAY(DATE(YEAR(G1), MONTH(A46)+1,0),-8)- (WEEKDAY(WORKDAY(DATE(YEAR(G1), MONTH(A46)+1,0),-8))=6)+ (WEEKDAY(WORKDAY(DATE(YEAR(G1), MONTH(A46)+1,0),-8))=2) IF I am off by one day in interpreting your "8th last working day", merely adjust the -8 factor accordingly. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1st and 3rd Thursday formula | Excel Discussion (Misc queries) | |||
How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
If the result of a formula is negative make equal to zero | New Users to Excel | |||
Make the result of a formula red (cannot be done in cond. format.) | Excel Discussion (Misc queries) | |||
Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions |