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