Sorry for changing the subject from the Mighty Clarets but some of us have to work!
I have designed a spreadsheet that counts days between various processes using the formula =NETWORKDAYS(A1,$S$1) where I have today's date in S1 =TODAY().
The spreadsheet works fine when I have a date in the A1 cell but if it's blank, I get a massive number like 32058.
Is there any way that I can tidy it up to either leave the cell blank or maybe with a zero until I enter data in A1?
Hope this makes sense to the Excel officianados on here!
Excel help....
-
StuffyClaret
- Posts: 469
- Joined: Tue May 03, 2016 8:15 am
- Been Liked: 144 times
- Has Liked: 93 times
-
MancunianClaret
- Posts: 463
- Joined: Tue Jul 05, 2022 2:46 pm
- Been Liked: 175 times
- Has Liked: 322 times
Re: Excel help....
I think this should work...
=IF(A1="","",(NETWORKDAYS(A1,$S$1)))
=IF(A1="","",(NETWORKDAYS(A1,$S$1)))
This user liked this post: StuffyClaret
-
MancunianClaret
- Posts: 463
- Joined: Tue Jul 05, 2022 2:46 pm
- Been Liked: 175 times
- Has Liked: 322 times
Re: Excel help....
To explain the above
IF(logical_test, [value_if_true],[value_if_false])
Or, in other words - if cell A1 = "" (blank), then show value "" (blank). If cell is not blank, then use formula =NETWORKDAYS(A1,$S$1)
IF(logical_test, [value_if_true],[value_if_false])
Or, in other words - if cell A1 = "" (blank), then show value "" (blank). If cell is not blank, then use formula =NETWORKDAYS(A1,$S$1)
This user liked this post: StuffyClaret
-
MancunianClaret
- Posts: 463
- Joined: Tue Jul 05, 2022 2:46 pm
- Been Liked: 175 times
- Has Liked: 322 times
Re: Excel help....
If that doesn't work try it with a zero
=IF(A1="",0,(NETWORKDAYS(A1,$S$1)))
(Sorry for the triple post)
=IF(A1="",0,(NETWORKDAYS(A1,$S$1)))
(Sorry for the triple post)
This user liked this post: StuffyClaret
-
wilks_bfc
- Posts: 11544
- Joined: Thu Jan 21, 2016 12:33 pm
- Been Liked: 3195 times
- Has Liked: 1875 times
- Contact:
Re: Excel help....
Mancunians answer should work or an alternative is
=If(isblank(A1),’’,(NETWORKDAYS(A1,$S$1)))
=If(isblank(A1),’’,(NETWORKDAYS(A1,$S$1)))
These 2 users liked this post: MancunianClaret StuffyClaret
-
Middle-agedClaret
- Posts: 1062
- Joined: Sun Jan 24, 2016 7:55 pm
- Been Liked: 332 times
- Has Liked: 1121 times
Re: Excel help....
…there are some very helpful and aware people on this Board…
These 2 users liked this post: Bosscat StuffyClaret
Re: Excel help....
Its a go to place ...Middle-agedClaret wrote: ↑Wed Nov 16, 2022 5:28 pm…there are some very helpful and aware people on this Board…
Today, still wanted by the government they survive as soldiers of fortune.
If you have a problem, if no one else can help, and if you can find them...
maybe you can hire The UTC-Team."
They love it when a plan comes together
These 2 users liked this post: StuffyClaret wilks_bfc
-
StuffyClaret
- Posts: 469
- Joined: Tue May 03, 2016 8:15 am
- Been Liked: 144 times
- Has Liked: 93 times
Re: Excel help....
Perfect.....thanks everyone!
-
cricketfield73
- Posts: 735
- Joined: Thu Jan 14, 2016 10:46 pm
- Been Liked: 424 times
- Has Liked: 441 times
- Location: Nelson
Re: Excel help....
A few years ago I had a similar(ish) question regarding an AutoCAD issue. Whilst there are mountains of sites dedicated to this subject, my first port of call was to just post a quick message in the hope that someone on here could help out. Within a few minutes I had several helpful responses (if my memory serves me well, the poster Rileybobs was particularly helpful) and my query was answered perfectly in no time at all.
I don't post on here too often, but there are certainly times when I am so glad that this messageboard is here.
It's great to have a facility like this on hand, especially with the Claret kinship - the one big thing that links us all together.
These 6 users liked this post: Bosscat StuffyClaret CoolClaret MancunianClaret Middle-agedClaret Zlatan