I am trying to calculate how many weeks before a given date that a payment was made. In this case certain types of payment are only considered if more than 52 weeks have passed since the payment was received. If less than 52 weeks have passed the payment is not considered.
number of weeks is the difference between the 2 dates divided by 7.
=IF( INT(DATEDIF(A1,TODAY(),"D")/7)>52,"Payment Considered", "Payment Not Considered")
Frob first, tweak later
This should do it
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks All,
Solved with
=DATEDIF(C12,H3,"d")/7
to get the number of weeks and use those in another conditional expression elsewhere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks