Hi guys so I have started this assignment based off of what I understood. However, I know my approach is wrong. Can someone help me out please.
Thanks,
Mahnoor Ibadat
SOLVED
Hi guys so I have started this assignment based off of what I understood. However, I know my approach is wrong. Can someone help me out please.
Thanks,
Mahnoor Ibadat
SOLVED
Last edited by mibadat; 11-06-2017 at 09:18 PM.
welcome to the forum. you could use a TODAY() formula somewhere say in cell E1 so that you don't have to keep recalculating it in column C and D:
=TODAY()
then in C2, try:
=DATE(YEAR($E$1),MONTH(B2),DAY(B2))
in D2, try:
=IF($E$1>C2,"Passed",C2-TODAY())
ps: please mark your thread as "Solved" once it has answered your question. you may look at my signature on several tips on how to mark it "Solved", some tips i compiled, and how to give a good eg in order to get quick answers.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks so much
Another way.
With current year in E1and next year in F1Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Array enter this in D2 and fill down.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
D E F G 1 Days Left 2017 2018 11/6/2017 2 39 3 315 4 196 5 137
Dave
What if DOB equals 29th Feb 1996?
Last edited by bebo021999; 11-06-2017 at 10:21 PM. Reason: change the year
Quang PT
DOB 2/29/1994 is not a valid date. 1994 is not a leap year.
Aha. I hadn't considered that. Mine won't work then.
Edit No wait a minute. It is working now. I was testing with pre-2017 dates in E1. Those won't work.
Last edited by FlameRetired; 11-06-2017 at 10:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks