Thread: [Solved] Problem writing Excel formula between two dates
View Single Post
 
Old 12-17-2021, 05:59 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
  
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default Problem writing Excel formula between two dates
Hello

I am trying to put a formula into a spreadsheet in order to calculate the number of days a project takes to complete. In some cases, I have both dates, in some a start date and in others a date when the job needs completing by. I want the No of Days cell to remain empty unless I have both dates. I have used the IF function but I think I need to add an OR but can't get it to work. Can someone please help me?


Start Date End Date No of Days
01/01/2021 31/12/2021 365
31/12/2021
01/01/2021 -44196

Many thanks for looking.
Reply With Quote