ConfusedMum
New Member
- Joined
- Apr 22, 2013
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hi all,
I am trying to count the number of days between two days (count to include both the start date AND the end date); however, to complicate things, it might be that the end date cell has a date in it, but the start date is showing as text or that the start date is fine, but that the end date is blank.
So far I have got the formula =IFERROR(DAYS(S2,G2), "Not fully complete")
- where S2 is the end date and G2 is the start date
- however, a few of the G2 cells have the wording in to show they need checking - so text, rather than the date
- and, a few of the S2 cells are blank not having an end date put in as yet
What I am trying to look for is a formula that looks at both S2 and G2 and if S2 is blank OR G2 is text then it returns "Not fully complete". At the moment it is working where G2 is text, but where S2 is blank I am getting -45078 for some reason!!
Any ideas please oh clever Excel minds!
Thanks so much, Cathy
I am trying to count the number of days between two days (count to include both the start date AND the end date); however, to complicate things, it might be that the end date cell has a date in it, but the start date is showing as text or that the start date is fine, but that the end date is blank.
So far I have got the formula =IFERROR(DAYS(S2,G2), "Not fully complete")
- where S2 is the end date and G2 is the start date
- however, a few of the G2 cells have the wording in to show they need checking - so text, rather than the date
- and, a few of the S2 cells are blank not having an end date put in as yet
What I am trying to look for is a formula that looks at both S2 and G2 and if S2 is blank OR G2 is text then it returns "Not fully complete". At the moment it is working where G2 is text, but where S2 is blank I am getting -45078 for some reason!!
Any ideas please oh clever Excel minds!
Thanks so much, Cathy