Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

dates

ResolvedVersion 2007

Christopher has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced course

Dates

How do calculate my date of birth with the correct formula. I did an exercise whilst training with yourselves but did not grasp it.


NOW
Today's Date
Your Birthday


Days Living
Years Living

Date in 15 days

RE: Dates

Hi Christopher

now is =now() Cell A1
todays date =today() Cell A2
your birthday Cell A3

Days Living =A2 - A3 Cell A5
Years Living = A5/365.25

Date in15 Days =A2+15


Hope that helps.

Cheers
Paul

RE: Dates

Hi Paul

I will give this a go and let you know. This looks very helpful.

Kind Regards

Christopher

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.