Hi I need a formula that will look at a start date and an end date and display the first available set of dates that fall within that period, it also needs to be flexible if the uset changes the start and end dates.
Please see the attached sheet for details.
Cheers
J
Hi John,
You have what you need in column M
so if(AND(start<c1,end>c2),EXAMPLE1,if(and(start<c1,end<c2),EXAMPLE2,if(and(start>c1,end<c2),EXAMPLE3,IF(AND(start>c1,end>c2),EXAMPLE4,"ERROR"))))
Something like that.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Let's try this.
1)Formula:
Please Login or Register to view this content.
2)Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
The problem I encounter is if the start or end date are equal with the Fy start or end date it can calculate them.
JD
change the > to >=
Is this a comment for my suggestion?
Cheers Guys, gonna go with Fotis's answer for simplicty, thanks for the quick replies.
JD
The forum froze when I tried to post a reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks