LinkBack URL
About LinkBacks
Hi
How would you calculate the day which represents the end of the month less, say, two work days? In June, the last day of the month is Monday 30th. Less two working days would bring the date back to Friday 27th. Can that be put into a formula?
Hi
How would you calculate the day which represents the end of the month less, say, two work days? In June, the last day of the month is Monday 30th. Less two working days would bring the date back to Friday 27th. Can that be put into a formula?
maybe
but your example is treating Sat/Sun as "working" days?
=EOMONTH(TODAY(),0)-3
Ben Van Johnson
I'm not sure that approach works. The problem arises that some end of months are on a Friday in which working days less 2 takes it back to Thursday. If the end of the month is a Monday, working days -2 takes it back to the previous Friday.
Refer workbook attached.Is this what you need?Formula:
=IF(WEEKDAY(EOMONTH($B$1,0),1)=2,EOMONTH($B$1,0)-3,EOMONTH($B$1,0)-2)
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Mr Saarang84 i think your formula will not works for the month of August'14 and September'14
See the attachement
Last edited by samba_ravi; 06-26-2014 at 03:43 AM.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks