LinkBack URL
About LinkBacks
Hello everyone,
I would like to know the function/syntax for determining the due dates given certain date ranges. see attached sheet for the example
Hello everyone,
I would like to know the function/syntax for determining the due dates given certain date ranges. see attached sheet for the example
Try this...
=IF(DAY(A3)<10,DATE(YEAR(A3),MONTH(A3),15),IF(DAY(A3)<25,EDATE(DATE(YEAR(A3),MONTH(A3),1),1)-1,EDATE(DATE(YEAR(A3),MONTH(A3),1),1)+15))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hope it works...
Cheers
thank you so much..this really work
@ mondon, happy to help and thanks for the feedback
@ azumi, nice formulaA quick observation, if you dont mind?
You dont need to use DAY(15), you can just use 15, and you did not need to use the AND(DAY(A3)>=10 part, the <10 in the beginning will cover that
Nice use of EOMONTH(), I forgot that 1 lol
@FDibbins
Yes you'reright, we both missed something..... haha..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks