Tuesday 24 November 2009

Hannah says dates in Excel are easy

Hannah says, if you want to get an updating date in Excel then it's quite similar to how it works in Access!

All you need is =now() in a cell and it'll sort out the date for you. You can format it to change what's included (Grace says you can also use =today() - but not =date() because that works differently.

You can also, just like in Access, use =now()+7 for example.

Hannah says you get the best of both worlds. Grace, otoh, says sweet niblets.

2 comments:

Anonymous said...

Sacrebleu! I'm confused! This website is weird, I prefer Green Circles :D

Blue Square Thing said...

Green circles aren't very cool though, are they? And they don't have a Hannah says tag either...