I have a spreadsheet that uses the formula =If(C52="","",Today())
it works well but when that line gets archived the date keeps counting.
What I want to say is (C52= todays date unless there is a date in F52 then = the date in F52)
can I use an if statement or should I be using a sumproduct?
Something like =IF(F52<>"",F52,TODAY()) work for you?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
I need to check for a check for a date in C52 when a date is entered it returns todays date.
When a job is closed a date will be put into F52 at that point I need the formula to say the cell is now = to the date in F52
Ok, this seems like it should be simple but I keep rereading it and am not sure I still follow it.
Will this work for you? =IF(C52<>"",C52,F52) Or does F52 override what is in C52? If this is true maybe this instead ... =IF(F52<>"",F52,C52)
I think whats confusing here is the cell in question.
Is the formula to go in C52, F52 or another one?
From the messages above you would have to assume that its in A N Other cell as you have referenced both C52 and F52, in that case
Which basically checks if F52 is a date and if so, uses that, if it isnt then it checks C52 and if available, uses that otherwise its blankPlease Login or Register to view this content.
In the file that I uploaded go to Dept 5811 on the bottom sheet tab.
For this explanation lets use line number 52
Look at cell L52 that formula returns todays date when C52's date is entered, if no date is there it remains blank.
The problem is when I close a job (put a date in f52) and hit the archive button at the top let of the sheet, it sends the line to archive but the date keeps counting.
When I enter a date into F52 I would like Cell L52 to return the value of F52, effectively stopping the date when I close the work order.
I hope that clears it up.
The formula I supplied should do that:
Please Login or Register to view this content.
IsDate is not a native Excel worksheet function.Originally Posted by pjwhitfield
It would be a good function to have, though!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
all I get in the cell is Name?
This is on the right track but when C52 is Null I don't want a date returned.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks