formula help

[BigBlackPiano]

Solved


Hi was wondering if anyone can help? I work with midwives and I need to create a spreadsheet where I can work out how many weeks pregant a woman is off her estimated due date as per below

a woman's pregnancy term is 40 weeks so in column one I have a date 07/05/2014 and in column two I want it to display how many weeks she is plus how many days. so when a woman's due date is 07/05/2014 that would mean that being today's date 8/5/2014 column 2 would display 40.1(because she is 1 day overdue so its 40.1) when the estimated date is placed in column one.


so to work out how many weeks pregnant the client is in midwifery pregnancy is calculated by weeks and days so if a woman is 28.2 it means she is 28 weeks and 2 days as per a 7 day week. I need to know the formula to place in a cell to calculate the weeks and days from the estimated due date.

to put it simply I want to type in column A1 a date of when the woman is due and a formula will calculate how many weeks and days she is pregnant from the date i have put in A1 and display this result in column B1

[:) Sixthsense :)]

..........................................

[BigBlackPiano]

I am new to all of this Im not sure what your post means Sixsense

[:) Sixthsense :)]

In A1 Cell - Enter the date

06/02/2014


In B1 Cell - For getting the Days alone

=DATEDIF(A1,TODAY(),"d") & " Days"


In C1 Cell - For getting the Weeks & Days

=INT(DATEDIF(A1,TODAY(),"d")/7) & " weeks And " & MOD(DATEDIF(A1,TODAY(),"d"),7) &" Days"

[:) Sixthsense :)]

I am new to all of this Im not sure what your post means Sixsense

I given the solution in Post #4

[Fotis1991]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#1 and amend your title
Then anyone will be able to help you.

[zbor]

There should be rule for giving infraction to users that answer such poor titled threads

[:) Sixthsense :)]

There should be rule for giving infraction to users that answer such poor titled threads

Please furnish the poor thread title's so that we can refer it before responding to such threads.

[Fotis1991]

Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum:

But if we refuse to accept the obvious...no discussion can be done!