|
|
#1
12-17-2021, 05:59 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 MS Excel formula problem
|
tabbymulla | Excel | 1 | 05-10-2018 12:08 AM |
| Macro or formula on Excel to Standardize dates | leonardo.sp05 | Excel | 7 | 02-13-2017 06:15 PM |
|
Excel formula problem/ Help required
|
dmcg9760 | Excel | 5 | 09-10-2015 09:42 PM |
|
formula writing for extracting data
|
jennamae | Excel | 1 | 11-15-2013 08:40 PM |
| font for the formula I am writing | vthomeschoolmom | Word | 1 | 01-30-2013 10:40 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode