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

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 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

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.

( 2018-01-31 11:12:47 +0100 )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.

( 2018-01-31 11:45:13 +0100 )edit

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

( 2018-01-31 12:16:28 +0100 )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.

( 2018-01-31 13:07:51 +0100 )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)))

( 2018-01-31 13:16:27 +0100 )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.

( 2018-01-31 13:36:37 +0100 )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?

( 2018-01-31 14:08:42 +0100 )edit

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

( 2018-01-31 16:09:05 +0100 )edit

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

( 2018-01-31 16:15:37 +0100 )edit

OK. this is my first time here. Thanks

( 2018-01-31 19:20:23 +0100 )edit

Sort by » oldest newest most voted

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

more