Get instant live expert help on if function using dates

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

If function for when one date is greater than another that excludes cells with no dates
Solved by E. J. in 30 mins
Hello I need to calculate time between dates and then use a function to use that as part of a larger calculation. I know how to run the calculation between two dates using "datediff" I need help with: If 1 has worked for my company less than 3 mths, 1 gets no sick pay, if 1 has worked for my company more than 3 mths, but less than 12 mths, then 1 gets 2 weeks full sick pay, If 1 has worked more than 12 months, one gets 5 weeks full sick pay. How do I express this in excel 2016 function(s) Is this possible within one cell, using the difference between two dates. Thanks very much.
Solved by F. E. in 11 mins
need help using the if function in excel
Solved by V. U. in 11 mins
i am using a date picker for selecting dates for few cells. However i also want to validate dates (like within a range, should be greater than... etc). However i found that if I put dates by using date picker, date validation does not work. Can you help please?
Solved by V. S. in 28 mins
I need help using the IF function to determine date
Solved by I. L. in 19 mins