Skip to main content

EXCEL help needed!!

Here’s a real world problem sent to me by a colleague. I think I’ll turn it over to my students for a couple days. Should be fun to watch.

 

I don't know if this is a good email address or not, but I thought I would try.  I need your help with something.  Since you seem to be our resident expert in Excel. :o)    Maybe you could put some of your students on this one...  (they're gonna love me for this!)

 

Here is my delima.  I want to automatically calculate the 'age' according to the dates (Date of birth vs. today's date).  You can see the formula below.  It works!!!  yay!  My problem, however, is that if there is no DOB entered, it calculates incorrectly.  I want it to return a 'Null' or 'error' or something indicating that information is missing.  Do you know how that could be accomplished?  I know that I could type something like 'N/A' in the DOB field and it would return a 'VALUE' error, but I don't want to have to mess with that.  Whatcha think?  You up for a challenge?

  

=DATEDIF(GD2,TODAY(), "y") & " years "

Date of Birth

Age

03/01/2000

9 years

06/18/2003

5 years

11/05/1996

12 years

 

109 years

109 years

109 years

 

Popular posts from this blog

Classcraft Interactive Notebook Page

Finished crafting interactive notebook pages for Classcraft, an engaging classroom management tool.

This fall I plan to add interactive notebooks to my classroom procedures. The goal is to provide students with something tangible to take home at the end of the semester. So that means creating or borrowing resources to guide students in developing their notebook.

Classcraft is a classroom management tool, an elaborate punishments and reward system designed like an epic role play game. Students create avatars and can upgrade pets and outfits based on experience and gold points earned. They can also lose points and suffer minor penalties. Everything is done in a fun, game like environment.

The computer lab is already divided into five or six stations, which lends itself easily to guilds or teams of students who work together in the game. I want students to develop their own backstory and choose their characters for the good of the group. I also need students to keep their login info some…

Easy Offline Lesson Plans

My lesson was on search engines, but the Internet was down. Learn how to have great offline backup plans.

So I had a room full of fifth grade students with a lesson plan on search engines. We were going to compare search results from different engines. We were going to learn how to refine our searches. We were not going anywhere because the Internet connection had gone down.

So I quickly checked with the librarian and moved my lesson offline. We selected books from the reference cart: dictionaries, atlases, encyclopedias and records books. I then gave students the same search queries from the lesson. We still compared results and discussed why some sources provided better results. We even contemplated if other libraries would have better selections or unique resources.

The trick to any offline lesson plan is understanding what concepts digital tools are built upon. Digital search is still the search for and analysis of information. For centuries, people have dug through catalogs of i…

Create A Custom Mobile Experience with Microsoft PowerApps

I recently dabbled with Microsoft PowerApps, creating a custom mobile experience for my own data collection process. PowerApps comes packaged with our Office 365 tenant so there was no additional cost. Overall it was fairly straightforward and easy to get up and running quickly.

Like so many things, the actual interface was quick to construct, most of it pulling from templates. Where most people will struggle is in the construction of the data management tools behind the app. I already had a working Excel spreadsheet for collecting data so that part was already done.

PowerApps quickly pulled together a mobile experience where I could sort, filter and search through spreadsheet data. I can also create additional lines in the spreadsheet using mobile form fields. I liked being able to make two separate apps for different sheets in the same workbook, helping to keep my data organized.

Now I already had the same Excel spreadsheet pinned to the home screen of my Android phone. So the Powe…