Excel IF formula with two dates as condition
I need to write a formula that looks at two dates; one being todays date and one being the start of a leave cycle.
the formula needs to calculate that if the difference between the two dates exceeds or equals 3 years, the balance in the one column needs to be 30.
is there anyone that can help?
A general way could be this.
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.
Re: Excel IF formula with two dates as condition
The above will work, providing there are no leap-years in between. The below should work, regardless. In this case, it assumes A1 has todays date and A2 has the date you are comparing. If you are not sure how to always have today's date in A1, simply putFormula:Please Login or Register to view this content.
In the cell making the calculation, paste the following
Formula:Please Login or Register to view this content.
A long old formula, but it should do the job
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks