Ask Your Question
0

In calc is there a formula to show what day my birthday will be on this year? [closed]

asked 2018-01-31 11:07:14 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

In calc is there a formula to show what day of the week my birthday will be on this year? And what day of the week I was born on?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Mark McLean
close date 2018-02-07 02:02:05.690514

Comments

1

Well, don't know about your birthday, but for my birthday - LO lacks a function BIRTHDAY_OF_MIKE_KAGANSKI :( - must be an oversight.

Seriously - you seem to need WEEKDAY function.

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-31 11:12:47 +0200 )edit

Thanks! It worked great for what day of the week I was born on. Not sure how to use it to know what day of the week my birthday will be on this year.

Mark McLean gravatar imageMark McLean ( 2018-01-31 11:45:13 +0200 )edit

=WEEKDAY("2018-01-04") ; =WEEKDAY(DATE(2018;01;04))

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-31 12:16:28 +0200 )edit

Thanks Mike. Got it I think. it returns the day of the week. I just can't get it to look ahead! if my birthday is March 30 1952, what day of the week will it be this year? I can't get a cell to take my birthday, and then to add up 66 years, to say March 30 2018, so that the format of that cell to say the day of the week for 2018. Thanks for your time and thought. Have a great day.

Mark McLean gravatar imageMark McLean ( 2018-01-31 13:07:51 +0200 )edit
1

If A1 contains March 30 1952, in B1 is Jan 31 2018, then you can do in C1: =WEEKDAY(DATE(YEAR(B1);MONTH(A1);DAY(A1)))

If in B1 you have 66 instead, then you can do =WEEKDAY(DATE(YEAR(A1)+B1;MONTH(A1);DAY(A1)))

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-31 13:16:27 +0200 )edit

IT WORKED! Thanks! It worked for all 33 of family and relatives birthdays. Not a must, just enjoy such, as you. Again, have a great day.

Mark McLean gravatar imageMark McLean ( 2018-01-31 13:36:37 +0200 )edit

One last but a different question I think you may know what i should do. I have a calc fill 955kb size that I use daily, I've had it for 2 years, (26 tabs, to many?). At times, (the last 8 months or so), it will have random errors, I hit F9 and every time it fixes it. Is it something that I should worry about? Or an easy fix? Or do you know who I should ask, if it is even something that should be fixed, seeing it is something I did while building it, and now ok with it?

Mark McLean gravatar imageMark McLean ( 2018-01-31 14:08:42 +0200 )edit

That should be opened as a new question rather than including it here.

Jim K gravatar imageJim K ( 2018-01-31 16:09:05 +0200 )edit

Also please do not post as community wiki (although my answer is an exception). See guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-31 16:15:37 +0200 )edit

OK. this is my first time here. Thanks

Mark McLean gravatar imageMark McLean ( 2018-01-31 19:20:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-01-31 16:04:25 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

From the comment by @Mike Kaganski

If A1 contains March 30 1952 and in B1 is Jan 31 2018, then in C1:

=WEEKDAY(DATE(YEAR(B1);MONTH(A1);DAY(A1)))

If in B1 you have 66 instead, then you can do:

 =WEEKDAY(DATE(YEAR(A1)+B1;MONTH(A1);DAY(A1)))

Please mark this as correct to close out the question. -Jim K

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2018-01-31 11:07:14 +0200

Seen: 49 times

Last updated: Jan 31 '18